Looking for a column that’s directly referenced by a stored procedure (sproc) then try running this query:
SELECT SProcName = OBJECT_NAME(object_id), Definition FROM sys.sql_modules WHERE definition LIKE '%SEARCH_CRITERIA%' ORDER BY SProcName;
This replaces the previous post.
If using MS SQL Server Management Studio 17+ then you need to make sure that the following option is checked:
Tools>Options>Query Results>SQL Server>Results to Grid>Retain CR/LF on copy or save
Otherwise carriage returns are lost. After checking the option you need to restart SSMS, for it to take effect on any queries.