March 2010 Entries

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'...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Posted On Wednesday, March 03, 2010 4:55 PM | Feedback (0)

Copyright © Neil Smith

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski