[blog]code til ur fingers bleed
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