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