how to know simultaneous connected count to a Database?

how to know simultaneous connected count to a Database?
Thank youStored Procedure 'sp_who' => Provides information about current Microsoft?
SQL Server? users and processes.
sp_who2 => list the active processes.
Lemme know if you were looking for this or something else.
Thanks,
Sree
"Asking" wrote:

> how to know simultaneous connected count to a Database?
> Thank you
>
>|||Were you looking something like below query?
Select COUNT(loginame) Count, loginame=rtrim(loginame)
From master.dbo.sysprocesses
GROUP BY loginame
Thanks,
Sree
"Asking" wrote:

> how to know simultaneous connected count to a Database?
> Thank you
>
>

how to know simultaneous connected count to a Database?

how to know simultaneous connected count to a Database?
Thank you
Stored Procedure 'sp_who' => Provides information about current Microsoft?
SQL Server? users and processes.
sp_who2 => list the active processes.
Lemme know if you were looking for this or something else.
Thanks,
Sree
"Asking" wrote:

> how to know simultaneous connected count to a Database?
> Thank you
>
>
|||Were you looking something like below query?
Select COUNT(loginame) Count, loginame=rtrim(loginame)
From master.dbo.sysprocesses
GROUP BY loginame
Thanks,
Sree
"Asking" wrote:

> how to know simultaneous connected count to a Database?
> Thank you
>
>

how to know simultaneous connected count to a Database?

how to know simultaneous connected count to a Database?
Thank youTo determine the number of current user database connections:
SELECT COUNT(*)
FROM master..sysprocesses
WHERE
spid > 50 AND
dbid = DB_ID('MyDatabase')
Hope this helps.
Dan Guzman
SQL Server MVP
"Asking" <asking@.ispro.net.tr> wrote in message
news:OSvVy06NGHA.3272@.tk2msftngp13.phx.gbl...
> how to know simultaneous connected count to a Database?
> Thank you
>