You could look at implementing DDL auditing which is now supported by SQL Server 2005.I have started testing this type of auditing in our dev environment and so far it seems to work very well.
Jasper Smith did a presentation at the PASS 2006 summit on building a complete DDL Auditing Application, you can download the source code for the sample application and the presentation from SQLdbatips.com, http://www.sqldbatips.com/showarticle.asp?ID=113.
Regards
Stevo
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply