question

ruancra avatar image
ruancra asked

Server DDL trigger history

Hi all Is it possible to see when and by whom a Server DDL trigger was enabled/disabled? SQL does not store this info in the logs. I have queried sys.triggers with no luck, any ideas? Thanks
sql-server-2008-r2triggerddl
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
You might be able to see that information from the default trace. You can [read about it here][1]. If you can't see it in the trace, then it is not available unless you set up extended events, DDL triggers, a different trace, yourself. [1]: http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ruancra avatar image ruancra commented ·
Thanks Grant
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.