SQL server2005查询数据库链接个数

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID]
IN
(
   SELECT
[DBID]
   FROM
[Master].[dbo].[SYSDATABASES]
   WHERE
NAME='databaseName'
)