Timeline for SQL Server 2008 R2 - Weekly / Monthly Statistics
Current License: CC BY-SA 3.0
3 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Aug 28, 2012 at 12:12 | comment | added | Aaron Bertrand | @RGI For DDL changes, I would recommend a DDL trigger instead of auditing. Much simpler to implement and consume. I wrote a tip about this here which covered stored procedures but could easily be extended to other objects: mssqltips.com/sqlservertip/2085/… Sorry, but I haven't done anything like this with auditing. | |
Aug 28, 2012 at 7:04 | comment | added | RGI |
can you please tell us how can we track the Schama changes using Auditing ? I tried to use SCHEMA_OBJECT_CHANGE_GROUP . My efforts are mentioned in this screenshoot.
|
|
Aug 24, 2012 at 23:21 | history | answered | Aaron Bertrand | CC BY-SA 3.0 |