Saved Bookmarks
| 1. |
What Is A Linked Server? |
|
Answer» LINKED Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs USING T‐SQL STATEMENTS. With a linked server, you can create very clean, easy to follow, SQL statements that ALLOW remote data to be retrieved, joined and combined with LOCAL data. Stored Procedure sp_addlinked server, sp_addlinkedsrvlogin will be used add new Linked Server. Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T‐SQL Statements. With a linked server, you can create very clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data. Stored Procedure sp_addlinked server, sp_addlinkedsrvlogin will be used add new Linked Server. |
|