General discussion

  • Creator
    Topic
  • #2100076

    Remote database via a stored proc

    Locked

    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.

All Comments

  • Author
    Replies
    • #3613647

      Remote database via a stored proc

      by bojidar alexandrov ·

      In reply to Remote database via a stored proc

      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.

    • #3564285

      Remote database via a stored proc

      by d-rempel ·

      In reply to Remote database via a stored proc

      This question was closed by the author

Viewing 1 reply thread