Post reply

Index rebuild date

  • February 9, 2009 at 12:21 pm

    #127451

    Hello All,

    This may be simple, but how do I find out when was the last time the index was rebuilt. I am trying to make sure my rebuild index script is working correctly. I am using SQL 2005. Any help is greatly appreciated

    Thanks

    Shri

  • February 9, 2009 at 1:21 pm

    #940777

    If you are really doing a rebuild then you can use the STATS_DATE function to get that information. Other than that, there is no definitive way to get the information that I know of.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • February 9, 2009 at 1:48 pm

    #940801

    shri_sastry (2/9/2009)

    Hello All,

    This may be simple, but how do I find out when was the last time the index was rebuilt. I am trying to make sure my rebuild index script is working correctly. I am using SQL 2005. Any help is greatly appreciated

    Thanks

    Shri

    You should store that information using your own script!


    * Noel

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

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