Search a particular text in all the stored procedure.

Submit Code |

Search Codes |

Code Home |

Generate a list of stored procedure names where a particular text is used.

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%SearchText%'

Thanks,
Debata

Found interesting? Add this to:

| More | Bookmark It

Responses
Posted by: T.saravanan \| Posted on: 4/26/2011 \| Level: Silver \| Status: [Member] [MVP] \| Points: 10 \| Alert Moderator Hi Debata, Kindly post your code inside the code tag its looking good. Thanks, T.Saravanan

>> Write Response - Respond to this post and get points

More codes snippets

simple way to zoom images in a datalist (images are retrieved from the database)
A simple way to slide images using jquery
To add,update,delete key,value pair of appsetting tag in web.config
To list key,value pairs of appsetting tag in webconfig and add it to hash table.
List Primary Key and structure of table like Column names,datatypes ,maximum character length
List User Defined Tables , Procedures,Functions in database in alphabetical order
Email,minimum length and required field validation using jquery
Using Windows Service - Generate Pdf
Validate INDIAN PAN Number Using Regular expression

Submit Code | More ...

Search a particular text in all the stored procedure.

Responses

More codes snippets