Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SP to search String in TEXT of SPs Expand / Collapse
Author
Message
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: Monday, April 14, 2014 6:47 AM
Points: 967, Visits: 450
Comments posted to this topic are about the item SP to search String in TEXT of SPs

Prasad Bhogadi
www.inforaise.com
Post #405040
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