Search
HomeHomeTechnology Rela...Technology Rela...SQL Server / Da...SQL Server / Da...Quickest/Easiest way to use Search/Replace through all stored procedures in SQL ServerQuickest/Easiest way to use Search/Replace through all stored procedures in SQL Server
Previous
 
Next
New Post
12/7/2019 10:59 PM
 

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%'

 
Previous
 
Next
HomeHomeTechnology Rela...Technology Rela...SQL Server / Da...SQL Server / Da...Quickest/Easiest way to use Search/Replace through all stored procedures in SQL ServerQuickest/Easiest way to use Search/Replace through all stored procedures in SQL Server