Index creation and Updated date in 2008

  • Hello everyone

    How do i know when index was created and updated in SQL Serve 2008?

  • 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.

    check this query

    select

    crdate,

    i.name,

    object_name(o.id)

    from

    sysindexes i

    join sysobjects o ON o.id = i.id

    order by

    crdate desc

    Thanks,

    Amit Kulkarni

  • This was wrong, crdate from the query is pointed to the table creation date, not the index.

Viewing 3 posts - 1 through 2 (of 2 total)

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