Query get the all the procedures which have a table or a column name specified as a parameters [closed]

I have almost 500 stored procedures in a database and need to find out how many or what are the procedures having the table name or name specified parameter.

I checked it on system object tables, but I’m not sure how to query it.

This can be achieved using this query:

SELECT DISTINCT so.name, so.*
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id = so.id
WHERE sc.TEXT LIKE '%parameter to search%'

Leave a Comment