select b.name,TEXT
from [dbname].dbo.syscomments a, [dbname].dbo.sysobjects b
where a.id=b.id and b.xtype='p' and a.text like '%[text]%'
[dbname]: 您要搜索的数据库名称
text:待搜索的文本内容
select b.name,TEXT
from [dbname].dbo.syscomments a, [dbname].dbo.sysobjects b
where a.id=b.id and b.xtype='p' and a.text like '%[text]%'
[dbname]: 您要搜索的数据库名称
text:待搜索的文本内容
转载于:https://www.cnblogs.com/fromchaos/archive/2010/03/02/1676472.html