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

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

sql server2005环境
SELECT  object_name(object_id)
FROM sys.sql_modules where definition like '%f_split_2%'

sqlserver 2000环境

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