Daily Archives: 5 de September de 2011

We know if a table is corrupt when we perform a simple select  and a error like this happens. Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xe61f1887; actual: … Continue reading →

Yes, we can monitor all changes to the event schema using AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT All Schema Changes : $query = “select * from AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT” Schema Changed by Alter $query = “select * from AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT where EventSubClass = 2” in the specific database … Continue reading →