Suppose you want to audit all failed deletions on the projects table in the company_operations database and for all new tables in the database. Use the object-specific delete option for the projects table and use default table for all future tables in the database. To set object-specific auditing options, you must be in the object’s database before you execute sp_audit:
sp_audit "security", "all", "all", "fail"
For this example, execute:
use company_operations go sp_audit "delete", "all", "projects", "fail" go sp_audit "delete", "all", "default table", "fail" go
