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


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.