Post reply

DDL Audit at Instance Level in SQL 2008

  • June 11, 2013 at 11:16 am

    #276201

    Hi Everyone,

    Can you please guide and correct me if I'm wrong somewhere...

    We need to capture all DDL events (only) in SQL Server 2008 R2..so as per my understanding I guess we have two of these options as below

    1) Triggers

    2) SQL Server Audit specification

    Now I further have a requirement to capture all the DDL events both in SQL 2008 and SQL 2005.

    But in SQL 2005 we don't have Audit specification (not sure), so only option left is triggers.. Please let me know if there are any other options or ways to do this in SQL 2005..?

    Also is SQL Server Audit Specification the best way to do the DDL Audits in SQL 2008, and what would be the best option then for SQL 2005?

    Thanks

    -Nivedita

  • June 12, 2013 at 1:05 am

    #1623223

    Hi,

    To capture the DDL events in SQL Server 2008 R2 and SQL Server 2005 like triggers and many other operations, I can suggest you to go in for a third party which can perform such sort of operations quickly because it will be a bit cumbersome to go in for a manual method. The tool can give information regarding each and every audit events of database objects(like triggers, user defined functions, etc.) as well as of SQL Server objects(like logins, alerts, DTS Packages, etc.). To know more features refer to http://www.sqlserveraudit.org/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply