beejug1983
SSCertifiable
Points: 6491
More actions
September 17, 2010 at 5:26 am
#226900
Hi
How to know the date & time of update of statistics in SQL Server 2005 ?
Please help.
Oliiii
Points: 5328
September 17, 2010 at 5:55 am
#1222905
Select *, STATS_DATE(object_id, stats_id) LastUpdate From sys.stats
You can join it with sys.objects to get the table name.
Adiga
One Orange Chip
Points: 27284
September 17, 2010 at 10:49 am
#1223190
Small tweak to Oliiii's query will give the object name as well
Select object_name(object_id), STATS_DATE(object_id, stats_id) LastUpdate From sys.stats
Pradeep Adiga Blog: sqldbadiaries.comTwitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply