sp_MSforeachdb @command1=' USE ?; IF NOT ("?" IN ("model","msdb","master","tempdb")) BEGIN EXEC sp_createstats; DECLARE @tbls TABLE (rowId INT IDENTITY(1,1), tblschema NVARCHAR(128), tblname NVARCHAR(128)); DECLARE @stmt NVARCHAR(2000), @rowId INT, @maxRowId INT, @tblschema NVARCHAR(128), @tblname NVARCHAR(128); INSERT INTO @tbls (tblschema, tblname) SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type="BASE TABLE"; SELECT @rowId = MIN(rowId), @maxRowId = MAX(rowId) FROM @tbls; WHILE @rowId <= @maxRowId BEGIN SELECT @tblschema = tblschema, @tblname = tblname FROM @tbls WHERE rowId = @rowId; SET @stmt = "UPDATE STATISTICS " + "[" + @tblschema + "].[" + @tblname + "];"; PRINT "?: " + @stmt; EXECUTE (@stmt); SET @rowId = @rowId + 1; END END ';