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?
This thread is now locked and can not be replied to.