Dear Developers,
We got a question today, Is it possible to use some sort of functionality to search through every stored procedure for a string and possibly replace it, like a standard Find/Replace function?
The answer is Yes and you don't need a tool to find it.
There are queries that can do that.
Select * From sys.sql_modules M Inner Join sys.objects O on M.object_id = O.object_id Where M.definition like '%text%'