Finding connected users

Hi Everybody
How to find about the connected users to the SQL Server.
Hi,
Login to Query analyzer and execute:
sp_who
or
use enterprise manager -- Management -- Current Activity -- Process Info.
Thanks
Hari
MCDBA
"Tanuj Ralhan" <anonymous@.discussions.microsoft.com> wrote in message
news:5EAF2D28-5FF1-475C-9E6F-17AD321395D3@.microsoft.com...
> Hi Everybody
> How to find about the connected users to the SQL Server.
|||also from QA sp_who2 , or select * from master.dbo.sysprocesses gives
additional data / different views
Also Perfmon / SQL Server:General Statistics/ User Connections
--
Andy Ball
Greenfell Computing Ltd
"Tanuj Ralhan" <anonymous@.discussions.microsoft.com> wrote in message
news:5EAF2D28-5FF1-475C-9E6F-17AD321395D3@.microsoft.com...
> Hi Everybody
> How to find about the connected users to the SQL Server.
|||How do user connections relate to concurrent connections or CAL.

Finding connected users

Hi Everybody
How to find about the connected users to the SQL Server.Hi,
Login to Query analyzer and execute:
sp_who
or
use enterprise manager -- Management -- Current Activity -- Process Info.
Thanks
Hari
MCDBA
"Tanuj Ralhan" <anonymous@.discussions.microsoft.com> wrote in message
news:5EAF2D28-5FF1-475C-9E6F-17AD321395D3@.microsoft.com...
> Hi Everybody
> How to find about the connected users to the SQL Server.|||also from QA sp_who2 , or select * from master.dbo.sysprocesses gives
additional data / different views
Also Perfmon / SQL Server:General Statistics/ User Connections
--
Andy Ball
Greenfell Computing Ltd
"Tanuj Ralhan" <anonymous@.discussions.microsoft.com> wrote in message
news:5EAF2D28-5FF1-475C-9E6F-17AD321395D3@.microsoft.com...
> Hi Everybody
> How to find about the connected users to the SQL Server.|||How do user connections relate to concurrent connections or CAL.sql