Procurar conteúdo dentro de uma view / procedure do SQL Server

Pesquisar conteúdo dentro da view

Select v.name, sm.definition
FROM sys.all_views AS v
JOIN sys.sql_modules AS sm ON sm.object_id = v.object_id
where sm.definition like '%product%'

Pesquisar conteúdo dentro da procedure

select p.name, sm.definition
from sys.procedures as p
JOIN sys.sql_modules AS sm ON sm.object_id = p.object_id
where sm.definition like '%product%'

Pesquisar conteúdo dentro de uma trigger

select t.name, sm.definition
from sys.triggers t
JOIN sys.sql_modules AS sm ON sm.object_id = t.object_id
where sm.definition like '%product_parents_hierarchy%'