Skip to main content

Searching within a Stored Procedure

Written by Gregory on . Posted in Binary.

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.