SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID]
IN
(
SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
WHERE
NAME='SWT_MicroManage'
)
go
SELECT COUNT(*) AS CONNECTIONS FROM master..sysprocesses
go
SP_WHO 'swt'
go