Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How many ways we can link a remote server?

Author  Topic 

zakeer
Starting Member

20 Posts

Posted - 2008-03-18 : 08:17:30
How many ways we can link a remote server?

I know we can do using linkedserver . Is there any others to do?

QAZAFI
Yak Posting Veteran

50 Posts

Posted - 2008-03-18 : 15:56:55
Firstly it depends what you are trying to achieve, if you are trying to access the data from another server you could have the option of Replication and mirroring. I don’t know what your intensions are. Please post the question in details so that any one can answers it. Many thanks
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-21 : 00:46:44
>> I know we can do using linkedserver . Is there any others to do?

openrowset, opendatasource
Go to Top of Page
   

- Advertisement -