查询某张表被哪些存储过程或者视图用到的sql语句

select distinct object_name(id) from syscomments  
where id in (select id from sysobjects where type  in('V','P'))  
and text like '%tablename%'