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.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-05-08 : 07:11:39
|
| Hello All,I just upgraded from sql server 2000 to sql server 2005, what script do I need to run to update the statistics to all the database? Please advice. Thanks. |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-05-08 : 07:24:23
|
| The stats should update automatically, but from Books On Line under UPDATE STATISTICS. You should read that first as there are options to choose from.UPDATE STATISTICS Sales.SalesOrderDetailJim |
 |
|
|
|
|
|
Updating Statistics script