select distinct a.name from sysobjects a,syscomments b where a.id=b.id and a.type='P' and charindex('str',[text])>0
查询包含字符串'str'的存储过程名:select t.name from sysobjects t where t.type='P' and exists(select 1 from syscomments where id=t.id and charindex('str',[text])>0)
--Sql2000 select * from syscomments where text like '%指定的字符串%' and id in (select id from sysobjects where xtype = 'P')select * from --Sql2005 select * from sys.sql_modules where definition like '%指定的字符串%' and object_id in (select object_id from sys.objects where type = 'P')
distinct a.name
from
sysobjects a,syscomments b
where
a.id=b.id and a.type='P' and charindex('str',[text])>0
t.name
from
sysobjects t
where
t.type='P'
and
exists(select 1 from syscomments where id=t.id and charindex('str',[text])>0)
select * from syscomments where text like '%指定的字符串%' and id in (select id from sysobjects where xtype = 'P')select * from --Sql2005
select * from sys.sql_modules where definition like '%指定的字符串%' and object_id in (select object_id from sys.objects where type = 'P')