Find strings in a stored procedure

Really simple... it returns a list of stored procedure names that contain the passed in string. Useful for finding all stored procedures that call another specified stored procedure. Call with the following command: exec usp_functions_findinUSP @str='sp_lastmodified'

3.5 (2)

2001-10-08

2,168 reads

Blogs

Why oh Why? Effects of Antivirus on a DB Server

By

At best these phantom backups cause undue headache in troubleshooting. At worst, they make...

Your First Jupyter Notebook

By

In April, I said I was going to start learning Jupyter Notebooks. It’s November....

Using Visual Studio Code

By

I’m a creature of habit. I have my routine when I get to my...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Turn If statement into Case

By GrassHopper

How can I convert this into a Case statement so that the query is...

The Conference Springboard

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Conference Springboard

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Missing Data

See possible answers