sql server2005环境
SELECT object_name(object_id)
FROM sys.sql_modules where definition like '%abc%'
sqlserver 2000环境
select object_name(id) from syscomments
where number=1 and text like '%abc%'
SELECT object_name(object_id)
FROM sys.sql_modules where definition like '%abc%'
sqlserver 2000环境
select object_name(id) from syscomments
where number=1 and text like '%abc%'