SQL Script to search stored procedures containing a given text

Posted on January 20, 2015 by vivekjohari
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the stored procedures which contains a  particular given text as input.
SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE ‘%Given text%’

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in DBA, SQL Advanced, SQL Server and tagged , . Bookmark the permalink.

32 Responses to SQL Script to search stored procedures containing a given text

  1. Pingback: วิธีใช้ App หาเงิน เพิ่ม !!!

  2. Pingback: Best lawyers in birmingham alabama

  3. Pingback: "Prada Foundation’s New display Is Dedicated To People In Love With Their Sex Dolls

  4. Pingback: Cellphone Repair Mission Texas 956-578-3511

  5. Pingback: Book Readers Accessories

  6. Pingback: tree service nashville tn

  7. Pingback: vitamin c serum

  8. Pingback: onion browser wiki

  9. Pingback: Dentist in Turlock California

  10. Pingback: ตอนเช้าขายอะไรดี

  11. Pingback: บาคาร่า

  12. Pingback: custom magnetic decal

  13. Pingback: https://certyfikowany.edu.pl/

  14. Pingback: Togelsumo

  15. Pingback: GCLUB

  16. Pingback: replica designer mens shoes

  17. Pingback: 안전공원

  18. Pingback: สอนเทรด Forex

  19. Pingback: 바카라사이트

  20. Pingback: เงินด่วน ขอนแก่น

  21. Pingback: how to get affiliate links on your blog

  22. Pingback: indoqq

  23. Pingback: w888

  24. Pingback: 카지노사이트

  25. Pingback: more tips here

  26. Pingback: vao fun88

  27. Pingback: p3301#jak długo trwa pozycjonowanie

  28. Pingback: p819#blog o marketingu

  29. Pingback: cornhole board plans

  30. Pingback: Dream Market Support

  31. Pingback: Agartha Market

  32. Pingback: ซี ฉัตรปวีณ์ ตรีชัชวาลวงศ์

Leave a Reply