Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create Trigger ddlTrigger_LogAlterTable
- On Database For ALTER_TABLE
- As
- Insert Into DropTableCommandLogs (
- EventType,
- PostTime,
- LoginName,
- UserName,
- DatabaseName,
- SchemaName,
- ObjectName,
- ObjectType,
- CommandText
- )
- Select
- EventType = EVENTDATA().value('(EVENT_INSTANCE/EventType)[1]', 'sysname'),
- PostTime = EVENTDATA().value('(EVENT_INSTANCE/PostTime)[1]', 'datetime'),
- LoginName = EVENTDATA().value('(EVENT_INSTANCE/LoginName)[1]', 'sysname'),
- UserName = EVENTDATA().value('(EVENT_INSTANCE/UserName)[1]', 'sysname'),
- DatabaseName = EVENTDATA().value('(EVENT_INSTANCE/DatabaseName)[1]', 'sysname'),
- SchemaName = EVENTDATA().value('(EVENT_INSTANCE/SchemaName)[1]', 'sysname'),
- ObjectName = EVENTDATA().value('(EVENT_INSTANCE/ObjectName)[1]', 'sysname'),
- ObjectType = EVENTDATA().value('(EVENT_INSTANCE/ObjectType)[1]', 'sysname'),
- CommandText = EVENTDATA().value('(EVENT_INSTANCE//TSQLCommand[1]/CommandText)[1]', 'nvarchar(max)')
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement