Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by James Greaves Monitoring and Recording DDL changes on SQL 2005 (NARC) RE: Monitoring and Recording DDL changes on SQL 2005 (NARC)
Sean Elliott (UK)
SSCommitted
Points: 1626
More actions
September 28, 2011 at 3:39 am
#1387626
create trigger ServerAuditTrigger
on all server
-- Audit server level and database level into dbadata.dbo.ServerAudit
-- The database level is also audited into <database>.dbo.DatabaseAudit
with execute as ''server_audit''for ddl_events