Daily Archives: 5 de September de 2011

PowerShell and SQL Server Events–Monitoring DATABASE SUSPECT DATA PAGE

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

Posted in Powershell, SQL SERVER EM GERAL, Virtual Pass BR | 1 Comment

PowerShell and SQL Server Events–Monitoring Schema Changed

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

Posted in Powershell, SQL SERVER EM GERAL, Virtual Pass BR | Leave a comment