Connecting to multiple servers (Sql server)

Question

I use windowform to create a report form but the data is for 4 different servers(SQL server). How can I organize data for the simplest query. Thanks.

Are your servers using a single data model or different for each? — Mikhail Tulubaev, Mar 07 '17 at 07:40
Please explain the situation correctly, by organizing you mean running the query on all server at once? Or are we talking about accessing data from each server and then manipulating in in code-behind? — GKG4, Mar 07 '17 at 07:48

score 0 · Answer 1 · edited May 23 '17 at 12:00

0

example:

SELECT *
FROM OPENQUERY(Linked_Server_Name , 'select * from Table')

edited May 23 '17 at 12:00

Community

answered Mar 07 '17 at 08:10

Dmitry Cat

1 Answers1