I have a Server Object\Trigger set up (inherited) as a logon trigger to look for not only the user name but the host it is coming from, if the host is incorrect, the connection is rejected.
The issue is that the Trigger magically went poof. So I am wanting to figure out how to not allow or at least notify if this happens again.
I was thinking of a Preventing DDL Action Trigger. however I am not sure since the trigger is in Server Objects not in a database specific.
CREATE TRIGGER TR_StopTriggerDelete
ON ALL SERVER