Click here to Skip to main content
16,020,822 members
Articles / Database Development / SQL Server

Find particular word or text from the entire stored procedure

Rate me:
Please Sign up or sign in to vote.
5.00/5 (1 vote)
26 Jan 2012CPOL 7.4K  
SELECT OBJECT_NAME(object_id), definition FROM sys.sql_modules WHERE definition LIKE '%GetEmployee%'

Views

Daily Counts

License

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


Written By
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions