asked
DBCC CHECKDB
Hi experts currently i need to create a agent job step with two parameters .DBCC CHECKDB with ALL_ERRORMSGS and NO_INFOMSGS . i am not sure how the query looks like . please help thanks
To pass in all error and no info you will need to do DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS If you want to do this on every DB on the instance, you may be best looking at Ola Hallengren's maintenance routines which cycle through each DB and run the DBCC CHECKDB commands. Alternatively you could look at sp_msforeachdb, but that is an undocumented feature and functionality of it may change, or write your own loop to cycle through each DB
18 People are following this question.
