Tag Archives: sys.procedures

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

T-SQL – Scripting Stored Procedure to Create backup copy on same database

This post is one of the request from OP. Download SQL  Backup SP in the same database The probelm statement 1:- Create a backup copy of a group of stored procedures on the same database.  Using TSQL I need to … Continue reading

Posted in SQL, T-SQL | Tagged , , , | Leave a comment