UPDATE STATS script

• manus4u

  Ten Centuries

  Points: 1238

  More actions

  September 19, 2008 at 5:30 am

  #71097

  Hi,

  Can someone provide me with a script which will run UPDATE STATISTICS on all tables of all DBs?

  I think, this can be used to update stats for all tables in a DB. But I am not sure how the table argument will be passed , which i have marked with '?'

  EXEC sp_MSForEachTable "update statistics'?'"

  Any help is really appreciated...

  Thnx

  Manu

• manus4u

  Ten Centuries

  Points: 1238

  More actions

  September 19, 2008 at 5:48 am

  #874132

  I think sp_updatetstats will update stats for all tables in a db;

  Still, if some one can help me to find a script for all tables in all DBs, that would be great!

  Thnx