Find particular word or text from the entire stored procedure

tarun_j200

5.00/5 (1 vote)

26 Jan 2012CPOL

7.5K

SELECT OBJECT_NAME(object_id), definition FROM sys.sql_modules WHERE definition LIKE '%GetEmployee%'

SQL

SELECT OBJECT_NAME(object_id), definition FROM sys.sql_modules WHERE definition LIKE '%GetEmployee%'

License

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