Skip to content

Instantly share code, notes, and snippets.

@kdarty

kdarty/Search-SQL-Server-For-Given-Search-Term.sql

Created July 2, 2014 12:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kdarty/e9460e23f2796207a504 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kdarty/e9460e23f2796207a504 to your computer and use it in GitHub Desktop.
Download ZIP
Search all SQL Server Modules (Procedures, etc) for given Search Term
Raw
Search-SQL-Server-For-Given-Search-Term.sql
-- Search all SQL Modules (Procedures, etc) for given Search Term
DECLARE @Search varchar(255)
SET @Search='what I am looking for'
SELECT DISTINCT
o.name AS Object_Name,o.type_desc
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id=o.object_id
WHERE m.definition Like '%'+@Search+'%'
ORDER BY 2,1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment