Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Database level trigger.
- CREATE TRIGGER AuditProcChanges
- ON DATABASE
- FOR CREATE_PROC, ALTER_PROC, DROP_PROC, CREATE_TABLE, ALTER_TABLE, DROP_TABLE
- AS
- DECLARE @ed XML
- SET @ed = EVENTDATA()
- INSERT INTO DDLAudit (PostTime, DatabaseName, Event, ObjectName, TSQL, Login)
- VALUES
- (
- GetDate(),
- @ed.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)'),
- @ed.value('(/EVENT_INSTANCE/EventType)[1]', nvarchar(100)'),
- @ed.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)'),
- @ed.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2000)'),
- @ed.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(256)')
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement