Blitz Result: 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.
This part of our SQL Server sp_Blitz script checks sys.server_triggers looking for is_disabled = 0 and is_ms_shipped = 0.
To Fix the Problem
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.
