dcsimg
Results 1 to 2 of 2

Thread: index usage in sql 2000

  1. #1
    Join Date
    Nov 2010
    Posts
    2

    index usage in sql 2000

    Hello,

    I need to find out how the indexes being used in the database, SQL 2000. Is it being used or not? If not, we can drop them to save up some spaces. Do you know of anyway we can do to get this inventory info.? I know there are features in SQL server 2005 and 2008. But I couldn't find for SQL 2000. Thanks in advance for your help.


    Thanks,

    Sunny,

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Not easy in sql2k, may need trace with profiler.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •