Display DB Connections

/* 
  SQL Server Display Database connections
 
  This script will show current connections to the specified database
*/
 
DECLARE @dbid int
DECLARE @dbname nvarchar(50)
 
SET @dbname = '[Enter the database name here]'
-- e.g. SET @dbname = 'mcsII'
 
SET @dbid = (SELECT DISTINCT(dbid) FROM master.dbo.sysprocesses WHERE db_name(dbid) = @dbname AND dbid <> 0)
 
SELECT spid,
	   ecid,
	   STATUS,
       loginame=rtrim(loginame),
	   hostname,
	   blk=convert(char(5),blocked),
	   dbname = case
					when dbid = 0 then NULL
					when dbid <> 0 then db_name(dbid)
				end
	   ,cmd
	   ,request_id
FROM  master.dbo.sysprocesses 
WHERE dbid = @dbid