Posted By

Maikel on 05/20/11


Tagged


Versions (?)

Find text within store procedure


 / Published in: SQL
 

  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  

You need to login to post a comment.