Hi there,
I have encounted the following errors when trying the script:
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.index_columns'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.index_columns'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.dm_db_index_usage_stats'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.indexes'.
Server: Msg 208, Level 16, State 1, Procedure vw_index_usage, Line 3
Invalid object name 'sys.filegroups'.
I guess it doesn't work on SQL 2000 (which is what I am using)?
Thanks!
Yvonne