active user sessions 1

[kindus]

How do I find the active user sessions in my sqlserver database?

thanks

 

[foxdev]

Execute the sp_who stored procedure; it will return the current connections. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[kindus]

thanks, it gives all processes in the database along with login name. Is there any other way in which I can get only one entry for each session ?

 

[tlbroadbent]

sp_who returns one row per SQL connection. Each connection has a server process ID or SPID which is listed in the sp_who output.

What do you mean by "one entry per session?" Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[foxdev]

I too have Terry's question, but an alternate tool would be to use SQL Server Profiler to view the activity, if that is more suited to what you are trying to do. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[kindus]

Thanks guys, when I say "one entry per session" I mnt the per server connection. When I tried sp_who, I saw two entry for one user say 'user1' while I saw only one server connection made for user1. May be it was something like connection window closed without disconnecting the user or whatever.