Find particular word or text from the entire stored procedure

Sunasara Imdadhusen

4.22/5 (9 votes)

22 May 2011CPOL

42.7K

SQL

SELECT distinct(OBJECT_NAME(id)) FROM syscomments WHERE text like '%GetEmployee%'

It will find text "GetEmployee" from the entire stored procedure in the database.

Thanks,
Imdadhusen

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)