Link of SQL Server to other Server

Question

Hi Friends I want to know that can I link SQL Servers to other other servers like Oracle and if it is possible then how can I do this ?

Jignesh Trivedi · Answer

hi Manish yes it is possible using Linked server in SQL Server. Configure a linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server. it has ability to access data from outside of SQL Server. Please refer.. http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/ http://www.sql-programmers.com/linked-servers.aspx hope this will help you.