Extended Stored Procedures

sp_Blitz® Result: Extended Stored Procedures in Master

You can roll your own stored procedures using .NET code, save them as DLLs, and register them in the master database. However, many DBAs don’t think to restore the master database when the production server fails, and we often don’t even think about end user code living in master.

This part of our SQL Server sp_Blitz® script checks sys.extended_procedures looking for rows.

To Fix the Problem

Make a list of the extended stored procedures and functions by querying:

SELECT * 
FROM master.sys.extended_procedures;
GO

SELECT *

FROM master.sys.extended_procedures;

Review the stored procs, find out if they’re in use, and consider them while making your backup/restore plans.

Return to sp_Blitz® or Ask Us Questions