Remote database via a stored proc
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.
Web Development
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.
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.
by d-rempel
by d-rempel
This discussion is closed to new replies.
Sort by Trending