<div>
<a href="http://my.re-invent.com/helpdesk/KB/a67/how-to-connect-to-sql-server-2008-2005-using-sql-server.aspx" rel="ugc">http://my.re-invent.com/helpdesk/KB/a67/how-to-connect-to-sql-server-2008-2005-using-sql-server.aspx</a>
</div>


http://my.re-invent.com/helpdesk/KB/a67/how-to-connect-to-sql-server-2008-2005-using-sql-server.aspx [http://my.re-invent.com/helpdesk/KB/a67/how-to-connect-to-sql-server-2008-2005-using-sql-server.aspx]

<div>
<div class="content wysiwyg-content">
I want to query a table in the remote DB server. <br />
<br />
Server A: 10.100.10.170 &nbsp; (2005)<br />
&nbsp; &nbsp; &nbsp; &nbsp; DB: MyAdmin<br />
&nbsp; &nbsp; &nbsp; &nbsp; Table: &nbsp;MyProcessType<br />
<br />
Server B: DEVSQL &nbsp;(2008)<br />
&nbsp; &nbsp; &nbsp; &nbsp; DB: MyAnotherAdmin<br />
<br />
I have connected to Server B (SQL Management Studio). Now I want to query (Server A).MyAdmin.dbo.MyProcessTy<wbr />pe from Server B in a T-SQL statement. <br />
<br />
How do I do this?<br />
<br />
<br />

</div>
</div>


I want to query a table in the remote DB server. 

Server A: 10.100.10.170   (2005)
        DB: MyAdmin
        Table:  MyProcessType

Server B: DEVSQL  (2008)
        DB: MyAnotherAdmin

I have connected to Server B (SQL Management Studio). Now I want to query (Server A).MyAdmin.dbo.MyProcessType from Server B in a T-SQL statement. 

How do I do this?




How to query a table in a remote DB server?

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.