SQL Server 2005 Change Auditing

Question

Is there a built in way in SQL Server 2005 to audit things specifically like deleting a stored procedure? Is there a history table that I can query? We have a mystery sproc that has disappeared a few times now.

Answer 1

You can build this using DDL triggers:

http://msdn.microsoft.com/en-us/library/ms190989.aspx