查询所有的存储过程哪些中包含某个字符串

查询所有的存储过程哪些中包含某个字符串

select sysobjects.name, sysobjects.id,syscomments.text  from sysobjects,syscomments where sysobjects.id=syscomments.id and  syscomments.text like '% f_split_2%'

select sysobjects.name, sysobjects.id,syscomments.text  from sysobjects,syscomments where sysobjects.id=syscomments.id and  syscomments.text like '%addre%'

 

sql server2005环境

SELECT  object_name(object_id) FROM sys.sql_modules where definition like '%c%'

sqlserver 2000环境

select object_name(id) from syscomments where number=1 and text like '%f_split_2%'