Geeks With Blogs
Neil Smith [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'

Posted on Wednesday, March 3, 2010 4:55 PM | Back to top


Comments on this post: Sql Server search stored procs for text

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Neil Smith | Powered by: GeeksWithBlogs.net | Join free