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
 General SQL Server Forums
 New to SQL Server Administration
 sql maintain

Author  Topic 

farrokhp
Starting Member

15 Posts

Posted - 2011-03-10 : 04:27:07
how can I know in sql2005 when was the last time stat_update happens in server?

revdnrdy
Posting Yak Master

220 Posts

Posted - 2011-03-10 : 10:56:39
I think you need to be more specific. What kind of update are you talking about. What are you specifically trying to capture?


r&r
Go to Top of Page

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-03-10 : 23:40:33

If you need Index update statistics Information then use below commands

sp_helpstats 'TableName', 'ALL'
DBCC SHOW_STATISTICS('TableName', IndexName)

--
Ragu Thangavel
Junier Sql Server DBA
Go to Top of Page

farrokhp
Starting Member

15 Posts

Posted - 2011-03-12 : 08:06:26
Thanks Ragu, that's what I was looking for
Go to Top of Page
   

- Advertisement -