Hi,

Can anybody help me, i'd like to know if there is a way to get index
usage in SQL SERVER 2000 through Transact sql, no through the Index
Tuning Advisor. Just like does SQL 2005 with dm_db_index_usage_stats.

Thanks in advance, or just for reading.

Hi
There is no such possibilty  in SQL Server 2000. I can think about runing
SQL Server Profiler to get a number of scaned objects , but it is not the
same



<GeneroDu***@gmail.com> wrote in message
Show quoteHide quote

The incredible new metadata is one of the main reasons I encourage people to
upgrade. There is a lot of information available in 2005 that has no
equivalent in 2000. The sys.dm_db_index_usage_stats view is my absolute
favorite. There was no good way to get this info prior to 2005. (Using the
Index Tuning Wizard was similar, but not nearly as easy or complete, and you
said you didn't want to use this tool.)

Show quoteHide quote

Backup error
High Pagelatch and threadpool
SQL 2005 Express to SQL Server 2000
Restoring a column in a table
Live server running out of space - Can't reduce Transaction Log!