declare @dbName varchar(20) --数据库名
select @dbName='test'
--详细信息
select * from master..sysprocesses where dbid=db_id(@dbName)
--数量
select count(1) from master..sysprocesses where dbid=db_id(@dbName)
select @dbName='test'
--详细信息
select * from master..sysprocesses where dbid=db_id(@dbName)
--数量
select count(1) from master..sysprocesses where dbid=db_id(@dbName)
检视登入使用者!!!