SQL SERVER 获取数据库中所有的表名及表中的数据量/查看每个数据库的链接打开数量

SQL SERVER 获取数据库中所有的表名及表中的数据量代码如下:

select  b.name as tablename ,  
        a.rowcnt as datacount  
from    sysindexes a ,  
        sysobjects b  
where   a.id = b.id  
        and a.indid < 2  
        and objectproperty(b.id, 'IsMSShipped') = 0
order by datacount desc

查看每个数据库的链接打开数量,代码如下:

SELECT dbid,DB_NAME(dbid) as DBName,hostname,status,last_batch 
FROM master.sys.sysprocesses 
--WHERE  DB_NAME(dbid)='查询数据库的名称' 
ORDER BY last_batch DESC