Server-Level Triggers Enabled

Database administrators don’t usually like triggers, but there’s a special kind of triggers that can be even trickier: server-level triggers.  For example, they can be fired on user logins to do things like reject a particular login outside of business hours.

We check sys.server_triggers looking for is_disabled = 0 and is_ms_shipped = 0.

Review the content of each server trigger and see what it’s doing.  If you don’t approve of it, save a copy of the code and drop it or disable it.