Category Archives: sp_updatestats for all user databases

Update Statistics for all the databases

By CH&HU @ PC on July 27, 2010 | 1 Comment

USE master
go

exec sp_MSforeachdb

‘ IF (”?” NOT IN (”master”,”tempdb”,”model”,”msdb”,”ReportServerTempDB”))

BEGIN
PRINT ”Updating Statistics” + ”?”
use ?
exec sp_updatestats
END’;