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: )

294 reads

Blogs

Programmatic Tool Calling with the Claude SDK

By

Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...

A New Word: Mauerbauertraurigkeit

By

mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...

Methodology for dealing with bad data in production

By

Pinal Dave wrote up his methodology for what to do when you discover bad...

Read the latest Blogs

Forums

VACATION!

By Grant Fritchey

Comments posted to this topic are about the item VACATION!

Why SQL Server Database Attach fails and how to repair it

By Nisarg Upadhyay

Comments posted to this topic are about the item Why SQL Server Database Attach...

Fixing P1 Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fixing P1 Queries

Visit the forum

Question of the Day

BIT_COUNT() IV

In SQL Server 2025, I run this code:

select bit_count('A')
What is returned?

See possible answers