Here is an example of a search of what is returned if I search the following text "acftfltinfo"

SELECT *
FROM Test.DBO.VWFLTINFO3 (NOLOCK)
-- From acftfltinfo Removed
where SchdDepDate>= @FromDate

But this code has been updated to the new view, If I was able to exclude comment text out of my search then this text would not return. I would I
to exclude this object because I do not care about it.

Also for the most part the view dependencies does not work for all case since it will only look in the current database and also does not work most of the time. It will miss which objects that are depend on [VWFLTINFO3] and bring back nothing becuase it is in a different datatbase. But Red-Gate Search works great. I also use the Red-Gate SQL Doc also for this process. Also with the Search will also show the code and I can click on the item and it brings the item into a new window for changes.

Also lets just say I'm looking for the text 'DELETE ITEM' in all databases.
If that text was in a comment block it will find that object.

For example would be returned, which is ok and good.

SELECT *
FROM TABLE
WHERE item = 'DELETE ITEM'

Object that I would like to exclude:
But search will still return this code also.

SELECT *
FROM TABLE
WHERE item = 'WORK FOUND' ----'DELETE ITEM'