The following will query the DDL text of all objects across all databases, returning details on any object that references a keyword you specify. This would include stored procedures, views, functions, triggers, and etc.
Just replace "InsertNameOfViewHere" with whatever keyword you're looking for.
set lock_timeout 10000;
set deadlock_priority low;
set transaction isolation level read uncommitted;
select db_name() + ''.'' + schema_name(o.schema_id)
+ ''.'' + o.name as object_name, m.object_id, o.modify_date, m.definition
from sys.sql_modules m (nolock)
join sys.objects o (nolock) on o.object_id = m.object_id
where definition like ''%InsertNameOfViewHere%'';
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho