SQL Server Developer Center >
SQL Server Forums
>
SQL Server Database Engine
>
when was a index last rebuilt in sql 2000
when was a index last rebuilt in sql 2000
- all,
is there any way to know when a particular index was last rebuilt.
i want to have a index rebuild job that resumes its operation after it is stopped at a particular index of a table.
thanks
nik
Answers
- That information is not stored anywhere.
- Marked As Answer byXiao-Min Tan – MSFTMSFT, ModeratorThursday, November 12, 2009 9:58 AM
All Replies
- That information is not stored anywhere.
- Marked As Answer byXiao-Min Tan – MSFTMSFT, ModeratorThursday, November 12, 2009 9:58 AM
- I would see from other way :
Reindex the tables which is frangmented.
conditional reindex
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!220.entry
HTH
Vinay
Vinay Thakur http://vinay-thakur.spaces.live.com/ http://twitter.com/ThakurVinay
