Find text within store procedure


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



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.