SQL-Server

Find particular word or text from the entire stored procedure

tarun_j200

Rate me:

Please Sign up or sign in to vote.

5.00/5 (1 vote)

26 Jan 2012CPOL 7.2K   1

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)

Written By

tarun_j200

 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

First Prev Next

Reason for my vote of 5 Correct. sql_modules has the complet... dmjm-h17-May-11 5:15 dmjm-h 17-May-11 5:15  Reason for my vote of 5 Correct. sql_modules has the complete text, unlike syscomments.

Last Visit: 31-Dec-99 18:00     Last Update: 24-Apr-24 6:40 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.