Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @TSQL nvarchar(2000)
- -- Filtering system databases and user databases from execution
- SET @TSQL = '
- IF (DB_ID(''?'') > 4
- AND ''?'' NOT IN(''distribution'',''SSISDB'',''ReportServer'',''ReportServertempdb'')
- )
- BEGIN
- PRINT ''********** Rebuilding statistics on database: [?] ************''
- USE [?]; exec sp_updatestats
- END
- '
- -- Executing TSQL for each database
- EXEC sp_MSforeachdb @TSQL
Advertisement