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

5 (1)

2007-03-01 (first published: )

1,147 reads

Blogs

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Returning To An Employer

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Returning To An Employer

SQL Server Collation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Collation

Replace calendar table multiplier column with date logic

By Chrissy321

Hello All, It's been a while. See the DDL/DML. I have a multiplier field...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers