http://sqlblog.com/blogs/davide_mauri/archive/2011/02/13/sys2-scripts-updated-scripts-to-monitor-database-backup-database-space-usage-and-memory-grants-now-available.aspxI’ve just released three new scripts of my “sys2” script collection that can be found on CodePlex: Project Page: http://sys2dmvs.codeplex.com/ Source Code Download: http://sys2dmvs.codeplex.com/SourceControl/changeset/view/57732 The three new scriptsenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/davide_mauri/archive/2011/02/13/sys2-scripts-updated-scripts-to-monitor-database-backup-database-space-usage-and-memory-grants-now-available.aspx#33515Tue, 15 Feb 2011 18:54:44 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33515Jim<p>I'm getting an error on the db_id() parens when I try to compile the operational stats function in SS2008 R2. &nbsp;It complains about the left parens. &nbsp;any idea?</p> http://sqlblog.com/blogs/davide_mauri/archive/2011/02/13/sys2-scripts-updated-scripts-to-monitor-database-backup-database-space-usage-and-memory-grants-now-available.aspx#33519Tue, 15 Feb 2011 20:52:33 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33519Davide Mauri<p>Hi Jim</p> <p>I've just tested it on SQL Server 2008 R2 and it work perfectly. I just did a copy and paste of sys2.indexes_operational_stats.sql from CodePlex to SSMS and I had no problem...</p> <p>If you execute the following query, do you still get an error?</p> <p>select * from sys.dm_db_index_operational_stats(db_id(), null, NULL, NULL)</p> <p>In my case it also works perfectly.</p>