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
>
>
Friday, February 24, 2012
how to know simultaneous connected count to a Database?
Labels:
connected,
database,
databasethank,
microsoft,
mysql,
oracle,
server,
simultaneous,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment