Advanced Search

Find Keywords in SQL Server Stored Procs and Functions

/ Published in: SQL
Save to your folder(s)
Find Keywords in SQL Server Stored Procs and Functions
Written By: Tim Ford

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

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.