查看字符段在哪些SP中出现

查看SQL的字段在哪些Stored Procedure中有出现

SQL：

declare    @i  varchar(100)
select    @i = '%FieldName%'
select    distinct b.name
from    syscomments a, sysobjects b
where    a.id = b.id and patindex(@i,a.text) > 0
order    by b.name
Go