sqlserver: how to search a table used in particular stored procedure
snippet in sql

sqlserver: how to search a table used in particular stored procedure

user8146

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