Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

Find text in SP


 / Published in: SQL
 

  1. -- Find text in a stored procedure
  2. SELECT so.[name] AS 'storedProcedure'
  3. FROM sysobjects so
  4. JOIN syscomments sc
  5. ON so.[id] = sc.[id]
  6. WHERE so.[type] = 'P'
  7. AND sc.[text] LIKE '%TEXT_YOU_WANT_TO_FIND%'

Report this snippet  

You need to login to post a comment.