Blitz Result: Startup Stored Procedure Found

SQL Server can run stored procedures in the master database automatically whenever it starts.  If you don’t know what these stored procs are doing, you could be in for some ugly surprises.  For example, some third-party security auditing software automatically starts up extra traces whenever SQL Server is started, and those trace output files are written to the system drive.  If you don’t know about those, the C drive can fill up and your server can stop dead.

This part of our SQL Server sp_Blitz script checks INFORMATION_SCHEMA.ROUTINES looking for stored procedures that are executed automatically on startup.

To Fix the Problem

Script out these stored procedures and review what they’re doing.  If you’re not satisfied with what they’re doing, you can back up the stored procedure and drop it or simply disable startup stored procedures.

Return to sp_Blitz or Ask Us Questions