How to create, configure and drop a SQL Server linked server using Transact-SQL

Linked servers allow getting data from a different SQL Server instance using single T-SQL statement. This article will explain how to create, configure and drop a SQL Server linked server using system stored procedures. Also, there is a way to create and configure a linked server to another SQL Server instance using SQL Server Management … Continue reading How to create, configure and drop a SQL Server linked server using Transact-SQL