Advanced Search

Find text within store procedure

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT sys.sysobjects.name, sys.syscomments.text
  2. FROM sys.sysobjects INNER JOIN syscomments 
  3. ON sys.sysobjects.id = sys.syscomments.id
  4. WHERE sys.syscomments.text LIKE '%TEXT%' 
  5. AND sys.sysobjects.type = 'P'
  6. ORDER BY sys.sysobjects.NAME

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.