Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 When an index was last rebuilt?

Author  Topic 

Hippi
Yak Posting Veteran

63 Posts

Posted - 2008-04-07 : 22:55:17
Hey folks,

Do you guys know how to figure it out when an index was last rebuilt?
I am searching for quite a while but can't find it.

Thanks.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-07 : 23:24:30
Take look at 'DBCC SHOW_STATISTICS'.
Go to Top of Page
   

- Advertisement -