Tag Archives: sp_helptext

SQL Server: How to backup and replace text in all search string matching Stored Procedure(s)

Table of Contents Problem Statement:- Solution:- Generate script for matching search string of all SP’s Using sp_helptext Using system view sys.procedures Generate modified SP’s script Create Linked Server Alias Conclusion References Problem Statement:- After SQL Server Migration or database rename … Continue reading

Posted in SQL | Tagged , , , | 1 Comment