DBCC checkdb hitsory
Posted on 2012-03-14
We have aroud 150 prod servers ad in each server 30-60 user DB's are der.
we have to capture DBCC CHECKDB history on DB wise(it inculdes servername,dbname,lastdbccrundate, duration).
kindly guide me how to achive above goal using tsql command.
Instead of executing each nd evry DB, need to execute script on master DB and this script will capture all DB's DBCC checkdb history on particular instance.
Thanks in Advance.