Date an index was created

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

I'm not sure There is a way to tell,

If you don't mind me asking, why do you need this information?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

The only date information about indexes can be found this way :

Select Name, CrDate from dbo.SysObjects where name in ('Primary key name','Unique constraint name') and XType in ('UQ', 'PK')

This will tell you the last creation date of a unique constraint or a primary key. That information is not kept for the indexes.

ofcoral Right there with Babe Points: 784 More actions · Answer 3

I have a request to create an index, but that index already exists.

I want to know when that index was created.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Can't know if that index is not a constraint (primary key or unique). There's just no information about that on indexes.

ofcoral Right there with Babe Points: 784 More actions · Answer 5

So, that is. May be SQLServer 2005 will give us to possibility to query the creation date of all objects in Db

Thanks

Larry