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.

Privacy • Earnings Disclaimer • Terms
© 2020 Gregory Brickner