Search Through Stored Procedure

[marksmithy69]

I am a total newbie to SQL Server, so I apologize for the simple question. Is there a way to search through all stored procedures for a text string? Thanks a lot.

 

[johnv20]

select text from syscomments where text like '%some string%'

 

[virtualranger]

I use the following query to search for all stored procedures in a db that contain a certain string:

SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE 'your search string here' 
    AND ROUTINE_TYPE='PROCEDURE'

Thanks,
Jamie

 

[marksmithy69]

Thanks a lot guys. Both examples worked great. I appreciate your help.