Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. Create Trigger ddlTrigger_LogAlterTable
  2. On Database For ALTER_TABLE
  3. As
  4.  
  5. Insert Into DropTableCommandLogs (
  6. EventType,
  7. PostTime,
  8. LoginName,
  9. UserName,
  10. DatabaseName,
  11. SchemaName,
  12. ObjectName,
  13. ObjectType,
  14. CommandText
  15. )
  16. Select
  17. EventType = EVENTDATA().value('(EVENT_INSTANCE/EventType)[1]', 'sysname'),
  18. PostTime = EVENTDATA().value('(EVENT_INSTANCE/PostTime)[1]', 'datetime'),
  19. LoginName = EVENTDATA().value('(EVENT_INSTANCE/LoginName)[1]', 'sysname'),
  20. UserName = EVENTDATA().value('(EVENT_INSTANCE/UserName)[1]', 'sysname'),
  21. DatabaseName = EVENTDATA().value('(EVENT_INSTANCE/DatabaseName)[1]', 'sysname'),
  22. SchemaName = EVENTDATA().value('(EVENT_INSTANCE/SchemaName)[1]', 'sysname'),
  23. ObjectName = EVENTDATA().value('(EVENT_INSTANCE/ObjectName)[1]', 'sysname'),
  24. ObjectType = EVENTDATA().value('(EVENT_INSTANCE/ObjectType)[1]', 'sysname'),
  25. CommandText = EVENTDATA().value('(EVENT_INSTANCE//TSQLCommand[1]/CommandText)[1]', 'nvarchar(max)')
  26.  
  27. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement