Advanced Search

Return to Snippet

Revision: 67745
at October 24, 2014 03:05 by heathbo
Initial Code 
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 '%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





SQL