How to identify all stored procedures referring a particular table

October 25, 2022 by Tarik

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'

BTW — here is a handy resource for this type of question: Querying the SQL Server System Catalog FAQ