Discussion Locked

Remote database via a stored proc

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a simple way to update a database that is on another SQL Server via a stored procedure? I do have a IP connection between the 2 servers. I am looking for a way that works on both MS SQL 6.5 and 7.0.

Thanks.

3 replies

by bojidar alexandrov

There are a couple of ways to do this
Best of them is thru database replication.
"Replication Types" Books Online of SQL Server (BOL)
It can be triggered manualy through SP.
Another way is with Linked Server
See this topic in BOL
"ConfiguringLinked Servers"
Then you can do Inserts between two servers and all kinds distributed queries.
See also OPENROWSET T-SQL function.

This discussion is closed to new replies.