Skip to main content

Searching within a Stored Procedure

Handy bit of code to search all of the stored procedures at one time:

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE ‘%customer%’
GO

This will return the stored procedure names that have “customer” in them if you are searching for the customer table for example.