<div>
You could with server replication which allows granular selection of what databases, tables, stored procedures, etc. that you want to send to the secondary server. &nbsp;Replication happens in real time.
</div>


You could with server replication which allows granular selection of what databases, tables, stored procedures, etc. that you want to send to the secondary server.  Replication happens in real time.

<div>
<div class="content wysiwyg-content">
I am looking for info on the following .<br />
<br />
Link Server to Server<br />
Link 2 databases in the same Servers.<br />
Link 2 databases each located in a separate Server.<br />
<br />
Is it possible to link the way you link from an ACcess database to SQL Server?
</div>
</div>


I am looking for info on the following .

Link Server to Server
Link 2 databases in the same Servers.
Link 2 databases each located in a separate Server.

Is it possible to link the way you link from an ACcess database to SQL Server?

Link SQL Servers or link SQL databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.