How to get detailed list of connections to database in sql server 2005?

sql-server database sql-server-2005 database-connection connection-pooling
x2. picture x2. · Jan 11, 2011 · Viewed 101.5k times · Source

How to get detailed list of connections to database in sql server 2005?

Answer

Brian Ball picture Brian Ball · Jan 11, 2011

Use the system stored procedure sp_who2.

Related questions

What is the point of "Initial Catalog" in a SQL Server connection string?

Every SQL Server connection string I ever see looks something like this: Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database; Integrated Security=SSPI; Do I need the Initial Catalog setting? (Apparently not, since the app I'm working on appears to …

Read More
How to check which locks are held on a table

How can we check which database locks are applied on which rows against a query batch? Any tool that highlights table row level locking in real time? DB: SQL Server 2005

Read More
Querying data by joining two tables in two database on different servers

There are two tables in two different databases on different servers, I need to join them so as to make few queries. What options do I have? What should I do?

Read More