View Users Connected to SLQ Server?

[Ryan McMinn]

Is there a utility that will allow me to see what users on my network are
connected/active on SQL server?

Ryan

[Greg D. Moore \(Strider\)]

"Ryan McMinn" <ry*********@songcorp.com> wrote in message
news:q1********************@news20.bellglobal.com. ..

Is there a utility that will allow me to see what users on my network are
connected/active on SQL server?
sp_who which is documented or sp_who2 which is similar but technically not
documented.


Ryan

[Simon Hayes]

"Ryan McMinn" <ry*********@songcorp.com> wrote in message news:<q1********************@news20.bellglobal.com >...

Is there a utility that will allow me to see what users on my network are
connected/active on SQL server?

Ryan

You can use sp_who2, or the Management - Current Activity tool in
Enterprise Manager to view connected users. Profiler is useful if you
need to track down a specific event, rather than get an overview.

Simon

[Sjaak van Esdonk]

Use enterprise manager / management / current activity /process info

[CptVorpal]

"Ryan McMinn" <ry*********@songcorp.com> wrote in message news:<q1********************@news20.bellglobal.com >...

Is there a utility that will allow me to see what users on my network are
connected/active on SQL server?

Ryan

Hey Ryan,

You'll find the function "sp_who" in books online to be very useful.
It'll give you some basic information about whose connected and very
vague information about their activity. Also see the function "kill"
as it will probably be your next question at some point :).

- CptVorpal