Sunday 14 October 2012

DBCC CHeckdb in one shot for all user databases

EXEC sp_msforeachdb 'use ?
IF DB_NAME() NOT IN(''master'',''msdb'',''tempdb'',''model'',
''ReportServer'',''ReportServerTempDB'')
DBCC CheckDB'
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)