time of last dbreindex

19 Mar 2005 7:48 AM

Hassan

Is there a way to find out when the last time indexes were rebuilt using
dbreindex ? I know theres a way to see when stats were last updated and sure
would be nice to know when indexes were rebuilt last

19 Mar 2005 2:01 PM

Wayne Snyder

As far as I know, there is no way to do that..there are no fields in the
system tables which indicate it, nor is it in the SQL error log.Anything
that is done you'd have to do yourself, like place something inthe log , or
put a row in a table.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

Show quote

"Hassan" <fatima***@hotmail.com> wrote in message
news:%23NYpWgFLFHA.436@TK2MSFTNGP09.phx.gbl...
> Is there a way to find out when the last time indexes were rebuilt using
> dbreindex ? I know theres a way to see when stats were last updated and
> sure
> would be nice to know when indexes were rebuilt last
>
>

19 Mar 2005 6:45 PM

Yogish

Hi,

Probably if you schedule index rebuild operation through maintenance job or
set it as sql job, you can know the time of its last run.

---------
Thanks
Yogish