how to see active SQL Server connections?

Question

Hello everyone,

I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, connect to which DB or something.

Any existing tools to solve this issue?

thanks in advance, George

Answer 1

You can use sp_who stored procedure.

Provides information about current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine. The information can be filtered to return only those processes that are not idle, that belong to a specific user, or that belong to a specific session.

Answer 2

A part from sp_who, you can also use the "undocumented" sp_who2 system stored procedure which gives you more detailed information. See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100099