To Check How May Connections are open in your Sql Server..

SELECT      DB_NAME(dbid) as DBName,      COUNT(dbid) as NumberOfConnections,     loginame as LoginName FROM     sys.sysprocesses WHERE      dbid > 0 GROUP BY      dbid, loginame