Return to Snippet

Revision: 67745
at October 24, 2014 03:05 by heathbo

Initial Code
SELECT DISTINCT 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 '%YourSearchTextHere%'

Initial URL

Initial Description
This query shows how to search all the files associated with a database for specific text.

Initial Title
SQL: How To Search All Files For Specific Text

Initial Tags

Initial Language