count the connections 1

[anhtri]

how to know that "how many connections are there that connected (at the moment) from different users to a specified database?"
Many thanks to any help

 

[magdyk]

in windows performance monitor
add counter
choose sql server:general statistics
u will monitor the number of connection connected to ur database

 

[anhtri]

thank you very much
but i didnt mean to monitor it, i write a VB program connect to a SQL Server database, and i just want to control the number of connections to that database throught my program
Pls help me

 

[anhtri]

Pls help!!!

 

[oneshadow]

i think you will have a better chance to get answer of your question if you post it in VB forum.

 

[tlbroadbent]

Select Count(*) As UserCnt
From master.dbo.sysprocesses p
Inner Join master.dbo.sysdatabases d
On p.dbid=d.dbid
Where d.name='dbname' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[anhtri]

you are very good Terry
thank you very very much ;-)