advanced code snippet search

Posted By

marcocs on 09/23/09


Tagged

admin Mantenimiento


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

sulfurito
Tyster


Find Keywords in SQL Server Stored Procs and Functions

 / Published in: SQL
 

URL: http://www.mssqltips.com/tip.asp?tip=1419

Find Keywords in SQL Server Stored Procs and Functions Written By: Tim Ford

Expand | Embed | Plain Text 
  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 '%KEYWORD%' 
  5. AND sys.sysobjects.type = 'P'
  6. ORDER BY sys.sysobjects.NAME

Report this snippet  

You need to login to post a comment.