Technical Article

Find and REMOVE string from stored procedures

This script extends the "Find strings in text of stored procedures" Script by LiviuB and and now finds thestring and removes it. You may modify script to just comment out the text.This script removes the text (in this case 'set dateformat dmy') from all non-system stored procedures in a database.Modify the variable @searchstring to contain […]

2004-11-26 (first published: )

268 reads

Blogs

Scary Scalar Functions - Part Two: Performance

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...

Goal Progress for June 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

Using Sessionize for Your User Group – Part 2

By

Now that your CFS has been setup it’s time to get the word out...

Read the latest Blogs

Forums

The July Fourth Anniversary

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The July Fourth Anniversary

Independence Day 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2022

Employee Hierarchy Recursive CTE Different Top Level Directors Overtime

By SQL_Kills

Hi, I have looked at some examples of Employee > Manager Hierarchy using Recursive...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers