sql server2005环境
SELECT object_name(object_id) FROM sys.sql_modules where definition like '%要查询的字符串%'
sqlserver 2000环境 select object_name(id) from syscomments where number=1 and text like '%要查询的字符串%'
sql server2005环境
SELECT object_name(object_id) FROM sys.sql_modules where definition like '%要查询的字符串%'
sqlserver 2000环境 select object_name(id) from syscomments where number=1 and text like '%要查询的字符串%'