Sql Server search stored procs for text

Search all stored procedures in a database for a string

SELECT routine_name, routine_definition 

FROM information_schema.routines

WHERE routine_definition LIKE '%textyoursearchingfor%'

AND routine_type = 'PROCEDURE'

Print | posted on Wednesday, March 3, 2010 4:55 PM

Feedback

No comments posted yet.

Your comment:





 

Copyright © Neil Smith

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski