• 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?

    Best Regards,

    Chris Büttner