SQL Script to search stored procedures containing a given text

DBA SQL Advanced SQL Server
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%’

32 thoughts on “SQL Script to search stored procedures containing a given text

  1. Pingback: vitamin c serum
  2. Pingback: onion browser wiki
  3. Pingback: Togelsumo
  4. Pingback: GCLUB
  5. Pingback: 안전공원
  6. Pingback: 바카라사이트
  7. Pingback: indoqq
  8. Pingback: w888
  9. Pingback: 카지노사이트
  10. Pingback: more tips here
  11. Pingback: vao fun88
  12. Pingback: Agartha Market

Leave a Reply