get list of the stored procedure which contains a

Get list of the stored procedure which contains a text ‘RAISERROR’ 

 

SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%RAISERROR%’ AND SPECIFIC_NAME   like ‘%api%’

You can get other important information using Information_schema, run the following query and get the stuff of your interest

SELECT* FROM INFORMATION_SCHEMA.ROUTINES

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s