Conection

Hello!!
Please help me!!
I want to know, if SQL server has a table where I can
find how many connections ar in this moment, or a
command. Or beteer,I what to know how many computers ar
login to SQL server ( USER ID or Network card ID) in this
moment.
Thank you,
IonutHi,
execute the below procedure from query analyzer:-
sp_who
or
use the system table to query the user connections, host name, network
address etc..:-
select * from master..sysprocesses
Thanks
Hari
MCDBA
"Ionut Terhes" <tjonut@.yahoo.com> wrote in message
news:c94a01c438f1$c6f56020$a001280a@.phx.gbl...
> Hello!!
> Please help me!!
> I want to know, if SQL server has a table where I can
> find how many connections ar in this moment, or a
> command. Or beteer,I what to know how many computers ar
> login to SQL server ( USER ID or Network card ID) in this
> moment.
> Thank you,
> Ionut|||You can also use sp_who2 which has additional information than sp_who.
Rand
This posting is provided "as is" with no warranties and confers no rights.