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.

Return to sp_Blitz or Ask Us Questions