Linked Server concept

Question

Hi I have two sql databases in different servers now one database is displaying information to the users in front end and i have to display data to the users by using two different servers database by using one database view. i know how to link the database. how can i present the data to the customer by using linked server concept. Ex: 1)EMP table is having firs database in first server 2)Dept table and view having second database in second server 3)by using second database view how can i present both EMP and Dept tables information into one output. Please help me on this issue. .

Rajeesh Menoth · Answer

Hi Check the following reference : http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/

Nirav Daraniya · Answer

Hi Vijay You already know about linked server  so first create linked server between both server. then try below query. SELECT S1.EMpNoS1.EmpNameS2.DepartmentName FROM [SERVER2\SQL2012].[DATABASE2DB].[dbo].[Dept] AS S2 [SERVER1\SQL2012].[DATABASE1DB].[dbo].[EMP] as S1 WHERE S1.EmpDepatmentId=S2.DeparmentId

Vinay Singh · Answer

Hi Try the below link http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/viewer.htm#a001361784.htm http://stackoverflow.com/questions/3918259/how-to-fetch-data-from-two-different-sql-servers http://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server