Alerting for corrupted databases

by Jul 11, 2017

Hi all,

I have a corrupted database for testing purposes. Is there a way to detect Errors thrown by DBCC checkdb?
Actually I have 1 allocation error and  2 consitency Errors after running checkdb. However, Diagnostic Manager DB State is green

I thought there should be a critical because database integrity is suspect (see http://www.idera.com/help/sqldm/7-5/default.htm#SQLdm/Database Status.htm)

select * from affected table row:SQL Server detected a logical consistency-based I/O error: incorrect checksum…