<div>
If you're joining them on a query, then yes.<br />
You'd need a linked server to Server2 and then you can query all the tables in Server2 as follows:<br />
<br />
Select * from Server2.myDataBase.owner.m<wbr />yTable<br />
<br />
And you can use it to join the tables as well.. 
</div>


If you're joining them on a query, then yes.
You'd need a linked server to Server2 and then you can query all the tables in Server2 as follows:

Select * from Server2.myDataBase.owner.myTable

And you can use it to join the tables as well..

<div>
what is this linked server. Can I get some sample code or screen-shots (even some link will do), that is good for explaining this.
</div>


what is this linked server. Can I get some sample code or screen-shots (even some link will do), that is good for explaining this.

<div>
Links can be accessed by me also. I was looking for some personal examples, describing remote servers names, how to install drivers and so on.
</div>


Links can be accessed by me also. I was looking for some personal examples, describing remote servers names, how to install drivers and so on.

<div>
<div class="content wysiwyg-content">
Can we join 2 tables on two different servers on 2 different databases? <br />
These 2 databases need 2 different connectionStrings for connection.
</div>
</div>


Can we join 2 tables on two different servers on 2 different databases? 
These 2 databases need 2 different connectionStrings for connection.

TSQL joining tables on different servers

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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.