Technical Article

Find Text in Database Objects (triggers / stored procedures)

I find myself refacoring an existing database which has some inefficient code, like cursors in stored procedures and triggers ...Wanting to figure out which objects contained this "poor" code, I made myself a little script to list all the objects which contain a search string.Just change the value that @search is set to and run […]

(1)

You rated this post out of 5. Change rating

2007-03-01 (first published: )

1,195 reads

Blogs

Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports

By

Originally published April 2022; substantially updated July 2026. This post is a complete replacement...

Getting Started with Azure SQL Developer on Macbook

By

The idea behind Azure SQL Developer is for anyone to build, iterate, and test...

AI Experiments: Claude Solved a DAB Issue

By

I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...

Read the latest Blogs

Forums

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Another Model, More Data Loss

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Another Model, More Data Loss

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers