1、
[code=SQLl]
select * from sys.objects s where s.type='p' and s.name like '%user_id%'
select * from sys.objects s where s.type='p' and s.name like '%user_id%'
[/code]
2、[code=SQ]Lselect name from sysobjects where id in (select id from syscomments where text like '%user_id%')[/code]
3、我用的方法是tasks里把所有存储过程保存出来,然后用nodpad++打开搜索。。。