Christian Buettner-167247 (1/18/2012)
I am not sure I understand the explanation.I would expect to find a row for the trigger in sys.all_objects, if it is said to be stored as an "object" in the master database. But sys.all_objects does not contain the server scoped triggers.
Why is that?
The BOL entry for sys.all_objects says:
"Shows the UNION of all schema-scoped user-defined objects and system objects."
Server-scoped DDL triggers are not schema-scoped.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi