In SQL Server 2005 and above, how can I find when an index was created?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
My answer is a direct quote of this link:
There is no direct way of finding the creation date of an index. But however if you look in sysobjects there is a creation date for Primary Key or Unique Constraints.Indexes associated with primary Primary Key or Unique Constraints creation date can be known.
check if there are any new DMVs (Dynamic Mgmt Views) in sql server 2008 which can help you in getting creationDate.
try this query
There is no way to know a single creation date of an index because it is not saved or collected by SQL Server.