查询那些存储过程中使用到了某个表

select name from dbo.syscomments c, dbo.sysobjects o  
where o.id = c.id and xtype = 'P' and text like '%表名%'