Find Index creation Date!!! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Find Index creation Date!!!

Author

Topic

malathic
Starting Member

6 Posts

Posted - 2007-07-20 : 02:05:08

Hi All,

I want find the date&time on which an index was created on a table. How will you do this?

I have looked in to all the system tables and I am not able to find this information. Sysobjects 'crdate' column lists the creation date of objects like

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

L = Log

FN = Scalar function

IF = Inlined table-function

P = Stored procedure

PK = PRIMARY KEY constraint (type is K)

RF = Replication filter stored procedure

S = System table

TF = Table function

TR = Trigger

U = User table

UQ = UNIQUE constraint (type is K)

V = View

X = Extended stored procedure

Please help!

Thanks

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-20 : 09:27:31

when i do :
SELECT *
FROM sysobjects
WHERE (name LIKE '%name index%') i get results for my indexes create date.

Need an SQLDB consultant?
check www.veeningsengineering.nl

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources