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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment