What is a Linked Server?

What is a 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.
Storped Procedure sp_addlinkedserver, sp_addlinkedsrvlogin will be used add new Linked Server.

Comments

Popular posts from this blog

What is the use of DBCC commands?

Google to FTS Syntax Cheat Sheet

What is difference between DELETE and TRUNCATE commands?