Is there a way to indentify when a index was created?

From: kirk cooper (kcooper7_at_yahoo.com)
Date: 06/21/04 

Date: 21 Jun 2004 08:29:02 -0700

Is there a way to know when a index was created? I see crdate in
sysobjects but nothing like that in sysindexes. SQL Server 2000 EE
sp3. Any information is appreciated.

Thanks,
Kirk

Relevant Pages

  • Re: Index Creation Date
    ... Mistake, mistake.. ... >>Join sysindexes and sysobjects and use the crdate in the ... Read details on SQL Server Books Online. ...
    (microsoft.public.sqlserver.security)
  • objects
    ... How to find the invalid and corrupted objects in ... sql server 2000? ... I tried sysindexes and sysobjects tables. ...
    (microsoft.public.sqlserver.server)
  • Re: Migrate SharePoint Portal 2003 and it DB Server to another ser
    ... I first applied WSS sp3, then rebooted then applied ... I have not rebooted my SQL server. ... Which order did you do the two SP3 installations? ... I am backing and restoring using the SharePoint backup and restore utility. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Neuinstallation
    ... Längerfristig solltest Du auch die anderen Rechner auf SP4 bringen. ... > Nach der Neuinstallation liess sich der Enterprise Manager nicht mehr ... SQL Server Verzeichnis existiereren. ... > Mit dem Aufspielen von SP2 und SP3 geht dieser Fehler auch nicht weg. ...
    (microsoft.public.de.sqlserver)
  • Re: SP4 performance Woes.
    ... Otherwise you can also enable trace flag 9059 to revert to the SP3 behaviour ... "Trace flag to revert to the behavior in SQL Server 2000 SP3") ... besides avoiding SP4 like a virus. ...
    (microsoft.public.sqlserver.setup)