locked
Index creation date RRS feed

  • Question

  • Is there a way to find out when an index both clustered and nonclustered was created in the dmv's, system tables or management studio?  Our company updates statistics weekly so the obvious date in the dmv's does not help as it only records the date statistics where updated.

    Scott

    Wednesday, July 28, 2010 5:48 PM

Answers

  • This information is not kept. You would have to set up a trace to keep track of it for yourself.

    If the index supports a primary key or unique constraint, there will be a row for the constraint in sys.objects with a creation date attribute, so that might help with some of your indexes.


    HTH, Kalen Delaney www.SQLServerInternals.com
    • Proposed as answer by Nishit Badani Wednesday, July 28, 2010 7:08 PM
    • Marked as answer by KJian_ Wednesday, August 4, 2010 8:12 AM
    Wednesday, July 28, 2010 7:04 PM