sqlserver 数据量查询，sqlserver每张表数据量

1.sqlserver查询哪些存储过程使用了某个表
select DISTINCT b.name from syscomments a,sysobjects b where a.id=b.id and a.text LIKE '%表名%' 

2.查询sqlserver每张表数据量

SELECT a.name as name, b. ROWS as datanum FROM sysobjects AS a, sysindexes AS b WHERE a.type = 'u' AND a.id = b.id AND b.indid IN (0, 1) ORDER BY a.name