Monday, March 26, 2012

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.

No comments:

Post a Comment