Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: Problem with replication

    When I try to insert a new record in the subscriber, into a published table, I get a error, saying that it could not execute a stored procedure in the remote server SQLOLEDB. But I when I insert a new record in the publisher, it works correctly, transmitting the changes to the subscriber. What's wrong with it? Both systems are windows 2000 server, with sql server 2000. Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    Please give us an idea what type of replication it is?

  3. #3
    Join Date
    Feb 2004
    Location
    Rhode Island
    Posts
    69
    - Do you have latest fix installed on the subscriber?
    - Does the insertion fire any triggers?

  4. #4
    Join Date
    Nov 2003
    Posts
    7
    It is a transactional replication. The error occurs when the subscriber is calling the remote stored procedure in the publisher, which updates the original table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •