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 […]

You rated this post out of 5. Change rating

2004-11-26 (first published: )

298 reads

Blogs

The Book of Redgate: Evidence

By

We aren’t the only company that does this, but Redgate Software does try to...

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

By

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....

Accessing the Data API Builder MCP Server from VS Code

By

I recently started playing with the MCP Server for SQL Server, which is a...

Read the latest Blogs

Forums

BIT_COUNT() V

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() V

How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager

By Pravalik Medi

Comments posted to this topic are about the item How We Reduced SQL Server...

An Eventual Consistency Scam

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Eventual Consistency Scam

Visit the forum

Question of the Day

BIT_COUNT() V

What does this return on SQL Server 2025?

select bit_count(null)

See possible answers