Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Prasad Bhogadi » SP to search String in TEXT of SPs
Add to briefcase

SP to search String in TEXT of SPs Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Prasad Bhogadi
Posted Monday, October 01, 2007 8:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 02, 2013 5:00 AM
Points: 967, Visits: 447
Comments posted to this topic are about the item SP to search String in TEXT of SPs


Prasad Bhogadi
Post #405040
gbobrowski-968732
Posted Monday, May 11, 2009 10:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 11, 2009 10:21 AM
Points: 1, Visits: 0
On SQL server 2005 it could be just that:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%whateverstringyouneedtofind%''
AND ROUTINE_TYPE='PROCEDURE'

Greg from Moxy Media in Guelph
Post #714313
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.