怎么用一条语句判断该数据库是否有无连接用户

SELECT * from master.dbo.sysprocesses  WHERE DBid=db_id('Test')

------解决方案--------------------

SQL code

select  *   from   master..sysprocesses   where   db_name(dbid)= 'master'

------解决方案--------------------

SQL code

要斷連接用Kill 

declare @spid int

select @spid=spid  from master.dbo.sysprocesses  WHERE DBid=db_id('Test')

exec('kill '+ @spid)

------解决方案--------------------

SQL code

if exists(select 1 from master..sysprocesses  where DBid=db_id('xx'))

...