Last stats update

• david.farnsworth

  Newbie

  Points: 6

  More actions

  October 25, 2007 at 10:11 am

  #199355

  I know that sp_helpstats 'tablename' gives some info on the columns updated for stats but I want to know the date of the last stats update. Any help please would be appreciated.

  Thanks,

  Dave

• Eddie Wuerch

  SSChampion

  Points: 12504

  More actions

  October 25, 2007 at 11:47 am

  #745451

  Check BOL for the STATS_DATE ( table_id , index_id ) function.

  -Eddie

  Eddie Wuerch
  MCM: SQL