declare @MyText nvarchar(4000)
set @MyText = '%fieldName%'

select
  so.xtype
  , so.name
from dbo.sysobjects so
where exists (select *
              from syscomments sc1
                left join syscomments sc2 on
                  sc1.id = sc2.id
                  and sc1.colid + 1 = sc2.colid
              where
                sc1.id = so.id
                and (right(sc1.text, 2000) + left(isnull(sc2.text, ''), 2000) like @MyText
                     or sc1.text like @MyText)
             )
order by
  so.xtype
  , so.name

Posted via ActualForum NNTP Server 1.3

Posted via ActualForum NNTP Server 1.3