SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name

(Pinal Dave) Before you read further, let me warn you that Logon triggers are potentially evil and might also end up locking everyone out of the instance. Be careful! Don’t just copy paste the code and create the trigger, you might end up in downtime to fix the issue.

Register to Read