Linked Server concept

vijay reddy

10y888

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth10y ago
Hi,
Check the following reference :
http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/
0
Nirav Daraniya10y ago
Hi Vijay,
You already know about linked server , so first create linked server between both server.
then try below query.
SELECT S1.EMpNo,S1.EmpName,S2.DepartmentName
FROM [SERVER2\SQL2012].[DATABASE2DB].[dbo].[Dept] AS S2, [SERVER1\SQL2012].[DATABASE1DB].[dbo].[EMP] as S1
WHERE S1.EmpDepatmentId=S2.DeparmentId
0
Vinay Singh10y ago
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
0