Good 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?