SQL Server 7

BlueSpud

Registered User
Messages
879
Anybody know an SQL string to query how many current connections there are to a database?
 
No, but close. This shows how many connections were open since SS was last started. I am looking for the number of currently open connections. Appreciate the effort though, thanks (yet again) Clubman.
 
Perhaps there's a standard (pseudo?) stored procedure for returning this info rather than a raw SQL query? It's been a while since I did SQL Server stuff in anger... :eek:
 
Is the section entitled "Using code to monitor performance counters" in [broken link removed] of any use? I'm not sure if this is .NET specific though...
 
Re: SQL Server 7 - ANSWER

Just found the answer, hope this might be usefull to someone.

exec sp_who2
exec sp_who2 active
 
Back
Top