Technical Article

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,185 reads

Blogs

RMOUG Training Days in Denver

By

Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...

Daily Coping 7 Feb 2023

By

Today’s coping tip is to go to bed in good time and allow yourself...

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Read the latest Blogs

Forums

Modify RDS page missing the Storage Autoscaling option

By jecobdruv

Hi folks, I have a single Postgres instance on RDS that in the past...

how to make a col in a table after checking its existence, in one stmt

By rajemessage 14195

hi, IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='abc' AND COLUMN_NAME IN...

Coaching the Digital Transformation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Coaching the Digital Transformation

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers