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