Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Could we select data from table in other Server
Message
From
19/03/2001 16:34:07
Bob Archer
Tampa, Florida, United States
 
 
To
19/03/2001 15:40:29
Jim Hou
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Could we select data from table in other Server
Miscellaneous
Thread ID:
00486601
Message ID:
00486628
Views:
10
>We have two servers (server1, server2). We are using server1 now. How can we select data from databse table in server2? and update tables in server1.
>
>Thanks
>
>Jim

Create a linked server. Look in the docs to see how to set this up. It is not to difficult.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform