i use this to find text in any db object:

-----------------------------------------------------

declare @criteria as varchar(32)

set @criteria = 'tadMSVRAreaDetail'

--:Utility proc for searching for dependents.":--

Select 'Checking references for (' + @criteria + ')'

Select distinct sysobjects.id, name, type

from syscomments, sysobjects

where syscomments.id = sysobjects.id

and ( text like '%' + @criteria + '%' OR text like @criteria + '%' )

order by name

--check for dependencies.

exec sp_depends @criteria

-----------------------------------------------------

I found it somewhere on the net, so i 'm not taking credit for this code, but I can tell you it's very handy