DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Search Particular Word Or Text From The Entire Stored Procedure In The Database
following code will find text "GetUsers" from the entire stored procedure in the database.
SELECT distinct(OBJECT_NAME(id)) FROM syscomments WHERE text like '%GetUsers%'
<a href="http://www.java-forums.org/java-software/"><strong>Java Software</strong></a>