How To Determine The Number of Open Connections In Sql Server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » How To Determine The Number of Open...

How To Determine The Number of Open Connections In Sql Server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

Stylez

Posted Monday, September 24, 2012 1:22 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:09 PM
Points: 47, Visits: 340

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?

Thanks

Noel

Post #1363699

Richard Moore-400646

Posted Monday, September 24, 2012 1:32 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:23 PM
Points: 154, Visits: 1,228

The query will work simply by removing the "sys." from sysprocesses. master..sysprocesses exists in SQL 2000.

Post #1363701

jeetsingh.cs

Posted Tuesday, December 04, 2012 11:51 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179, Visits: 380

SELECT
COUNT(dbid) as TotalConnections
FROM
sys.sysprocesses
WHERE
dbid > 0
If more information is required
use
sp_who2 'ACTIVE'

Post #1392805

« Prev Topic | Next Topic »

Permissions