General discussion

Locked

Remote database via a stored proc

By d-rempel ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Remote database via a stored proc

by Bojidar Alexandrov In reply to Remote database via a sto ...

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.

Collapse -

Remote database via a stored proc

by d-rempel In reply to Remote database via a sto ...

Poster rated this answer

Collapse -

Remote database via a stored proc

by d-rempel In reply to Remote database via a sto ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums