×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

Find all Stored Procedures, views, functions that contains specific text

0
0
 
0
Language: SQL
Posted by: Arturo Bardelli
Added: Jan 23, 2017 1:15 PM
Views: 2248
Tags: function sqlserver storedprocedure view
  1. SELECT DISTINCT a.[name]
  2. FROM sysobjects a
  3. INNER JOIN syscomments b ON a.id = b.id
  4. WHERE b.[text] LIKE '%[search-term]%'

Write a comment

To post comments, please log in or register.