kodaksmile
MIS
Hi,
Just wondering if in SQL 7 there is a way to tell when an index was rebuilt last?
Thanks!
Just wondering if in SQL 7 there is a way to tell when an index was rebuilt last?
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to tell when an index was rebuilt last
- Thread starter kodaksmile
- Start date
- Status
ptheriault
IS-IT--Management
IF you run DBCC SHOWCONTIG it will show you how fragmented the index is. I'm not sure if SQL 7 can tell you the last time an was rebuilt. you can look at the create date in the sysobjects table.
- Paul
- Database performance looks fine, it must be the Network!
- Paul
- Database performance looks fine, it must be the Network!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question