<div>
<blockquote>
I have two databases configured with similar names.
</blockquote>
In the same instance? That's impossible.<br />
Please clarify where those two databases are.<br />
<br />

<blockquote>
I want to identify which one without looking at the client side.
</blockquote>
Assuming that the databases with the same name are in different instances, you need to connect to each instance and run the command <b>sp_who2</b>. This stored procedure returns all connections to the respective instance and has information about the user, application and the client computer that is connecting.
</div>


<div>
<div class="content wysiwyg-content">
I have two databases configured with similar names. An application on my network communicates with one of the databases. I want to identify which one without looking at the client side. Is there anything I can view in SQL 2005 that will tell me which one is the active one. thanks
</div>
</div>


I have two databases configured with similar names. An application on my network communicates with one of the databases. I want to identify which one without looking at the client side. Is there anything I can view in SQL 2005 that will tell me which one is the active one. thanks

SQL 2005 active database

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.