Post reply

Index creation and Updated date in 2008

  • July 29, 2010 at 2:39 am

    #227267

    Hello everyone

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

  • July 29, 2010 at 6:18 am

    #1199730

    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

  • January 23, 2015 at 9:41 am

    #1772720

    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