Wednesday, March 3, 2010 #

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'

Posted On Wednesday, March 3, 2010 4:55 PM | Comments (0)

Copyright © Neil Smith

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski