<div>
sp_who and sp_who2 give you connections to every database. &nbsp;That's why there is a dbName column.
</div>


sp_who and sp_who2 give you connections to every database.  That's why there is a dbName column.

<div>
You are correct. &nbsp;I was to hasty in looking at the result set. &nbsp;Thanks.
</div>


You are correct.  I was to hasty in looking at the result set.  Thanks.

<div>
<div class="content wysiwyg-content">
I need to know write a query to show all users logged into a particular instance of a MS SQL 2005.<br />
<br />
This instance contains multiple databases.<br />
<br />
I know of sp_who and sp_who2 but that only seems to give me information for one database at a time.<br />
<br />
I am looking for an aggregate of all users on all databases in a single instance.
</div>
</div>


I need to know write a query to show all users logged into a particular instance of a MS SQL 2005.

This instance contains multiple databases.

I know of sp_who and sp_who2 but that only seems to give me information for one database at a time.

I am looking for an aggregate of all users on all databases in a single instance.

SQL Query to show all users logged into one instance

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.