Chris Holding (11/4/2010)
This works for SQL 2005 and above but I'm having problems with SQL 2000; can anyone rewrite for SQL 2000?
No, because the information is not there in SQL 2000.
If you want this kind of info in SQL 2000, you'll need a trace (SQL Trace)
Is there and equivalent for sys.dm_db_index_usage_stats etc in SQL 2000?
No
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability