Search for All the Stored Procedures Name that have a specific column
-- For All Objects SELECT OBJECT_NAME(object_id) , definition FROM sys.sql_modules WHERE definition LIKE '%' + 'PhaseID' + '%' -- For Stored procedures only SELECT DISTINCT OBJECT_NAME(object_id) , OBJECT_DEFINITION(object_id) FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE '%' + 'PhaseID' + '%'