Linking two sql servers and accessing data

  cyberpharmacist 11:58 17 Nov 03
Locked

Hi All,

I am wondering if any one knows how to link two servers up in SQL server and access the data from one server to other.

I have two SQL servers, both running SQL server 2000 and I have linked the server from SQL1 to SQL2. However, I have no idea how to access the data from SQL2 to SQL1 or vice versa. Can some one please help?

Many thanks!

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now