InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:14:04 GMT20http://www.sqlservercentral.com/Forums/Topic902093-2673-1.aspxVery good. In fact, this is necessary. Thanks.Sun, 18 Apr 2010 19:33:37 GMTadeilsonrbritohttp://www.sqlservercentral.com/Forums/Topic902093-2673-1.aspxHi,I have some databases with spaces in the names and so I added some square brackets;USE mastergoexec sp_MSforeachdb ' IF (''?'' NOT IN (''master'',''tempdb'',''model'',''msdb'',''ReportServerTempDB''))BEGIN PRINT ''Atualizando estatísticas de '' + ''?''use [?] exec sp_updatestats END';Thanks for the useful snippet!Sun, 18 Apr 2010 18:52:21 GMTAndrewB-Ahttp://www.sqlservercentral.com/Forums/Topic902093-2673-1.aspxNo problem. Thanks for your message.Sat, 17 Apr 2010 06:01:11 GMTadeilsonrbritohttp://www.sqlservercentral.com/Forums/Topic902093-2673-1.aspxHa! I must not have had my first cup of coffee before making that post. Good call.Fri, 16 Apr 2010 14:14:11 GMTdelamaterhttp://www.sqlservercentral.com/Forums/Topic902093-2673-1.aspxBecause sp_updatestats just update statistics in all tables in the current database.Fri, 16 Apr 2010 10:14:50 GMTadeilsonrbritohttp://www.sqlservercentral.com/Forums/Topic902093-2673-1.aspxWhy not use sp_updatestats?Fri, 16 Apr 2010 08:50:29 GMTdelamaterhttp://www.sqlservercentral.com/Forums/Topic902093-2673-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/statistics/70012/">Update statistics in all databases</A>[/B]Mon, 12 Apr 2010 19:43:48 GMTadeilsonrbrito