Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 update statistics

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2010-06-08 : 08:27:32
Hi,

Assuming am running the sp_updatestats against the database manually without a daily job which should be the actaul case on any production environment.
Is there any way through which i can say whether my statistics on a particular database is up-to-date or can i extract from any system table that when the last update stats has been run on my database ???

Thanks in Advance

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-08 : 08:39:52
maybe this:
http://msdn.microsoft.com/en-us/library/ms190330.aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -