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 2000 Forums
 SQL Server Development (2000)
 Connecting two Remote SQL Server?

Author  Topic 

Mits
Starting Member

48 Posts

Posted - 2003-12-08 : 07:47:42
i have two SQL servers.
How do i update records from one table of one server to another.
Both SQL server machine has different IP address and are not in same domain.

Please advise me in deatil.

Thanking you in advance

Mits

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-12-08 : 08:10:02
Hi!

Look up sp_addlinkedserver and sp_addlinkedsrvlogin in BOL.
Go to Top of Page
   

- Advertisement -