Search for a specific string inside a SQL View object.

tools-search-view-definitions.sql

DECLARE @search VARCHAR(1000)
SET @search = '%friendly%'

SELECT v.name, c.[Text]
FROM dbo.sysobjects AS v
INNER JOIN dbo.syscomments c ON c.id = v.id
 AND CASE WHEN c.Number > 1 THEN c.Number
   ELSE 0 END = 0
WHERE v.type = 'V' AND c.[Text] LIKE '%' + @search + '%'