question

Mandar Alawani avatar image
Mandar Alawani asked

Find last reindex time in SQL Server 2000

Hi, Is there a way to find the last reindex time for any table/index in SQL Server 2000 (it would be great if there is a genric query for all tables in a database), similar to something like below which is applicable only in SQL Server 2005? USE AdventureWorks; GO SELECT name AS Stats, STATS_DATE(object_id, stats_id) AS LastStatsUpdate FROM sys.stats WHERE object_id = OBJECT_ID('Sales.SalesOrderDetail') and left(name,4)!='_WA_'; GO
sql-server-2000indexingrebuild
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.