This query comes in pretty handy at times. Brute force way of looking for stored procedures having certain text (table name, views, functions), finding dependencies.
Select distinct object_name(id) from syscomments where charindex('String here', text) > 0 order by object_name(id)
