InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 08:39:42 GMT20http://www.sqlservercentral.com/Forums/Topic1363699-1291-1.aspxSELECT COUNT(dbid) as TotalConnectionsFROM sys.sysprocessesWHERE dbid > 0If more information is requiredusesp_who2 'ACTIVE'Tue, 04 Dec 2012 23:51:24 GMTjeetsingh.cshttp://www.sqlservercentral.com/Forums/Topic1363699-1291-1.aspxThe query will work simply by removing the "sys." from sysprocesses. master..sysprocesses exists in SQL 2000.Mon, 24 Sep 2012 13:32:17 GMTRichard Moore-400646http://www.sqlservercentral.com/Forums/Topic1363699-1291-1.aspxGood Afternoon Guys,would it be possible to know the number of connections a person has in a Database in Sql Server 2000? i saw a query that actually counts the number of connection but only runs in SQL Server 2005. here is the query.SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame is there anything similar in SQL server 2000 that does the same thing that the query stated above does?ThanksNoelMon, 24 Sep 2012 13:22:11 GMTStylez