Search particular word or text from the entire stored procedure in the Database

Monday, 19 December 2011 00:32
the-from-text-distinctobject_nameid-database select
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%'

Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/oce8hWa5obQ/14225

Scroll To Top