SQL Server 2005 - DDL Triggers - Setting Up Auditing
New with SQL Server 2005, is the ability to set up triggers on DDL statements. This has got to be a DBA’s dream come true. You can set up audit logs on creates/alters, etc. Here is how you do it (this is just a trigger, you will need to create the table, you should be [...]
Leave a Comment | 196 views
