Hi folks,

Is there a way to find out when was the last time an index was rebuilt?
Is this information is available in any system tables?

Thx,
Ram

That information is not stored.

Show quoteHide quote

Heh heh, when you issue the DBCC command, write it down in your notebook.
SQL Server does not track this information.  If you wish to track this
information, you'll have to do it yourself.  For example, you could have a
stored procedure that issues the DBCC command(s) and logs to a table.

A


Show quoteHide quote

Why? If you're trying to schedule regular index rebuilds, do this by
examining actual fragmentation, rather than estimating the amout of time that
should elapse between each defragmentation (rebuild).

See "DBCC SHOWCONTIG" in Books Online.


ML

can't return zero when no rows exist using aggregate function sum
Trigger not executing stored proc ...
UPDATE statement behavior with derived table
Redundant Power Supply
Table name as a variable