sql server replication: Distributor Agent -- sql server replication

Distributor Agent

John
2/6/2004 2:01:05 PM

sql server replication:

Hi All

My distributor agent is stopped while we got error with FK relation in that table.

The error is like Call : CALL sp_MSdel_Order

How i can resolve this issue

Thanks

Distributor Agent

Paul Ibison
2/6/2004 2:48:20 PM

You could resolve the FK error then restart the agent.
Alternatively you can use SKipErrors with the relevant
error number and resolve it using linked servers. If the
PK-FK tables are articles in the same publication this
ordinarily shouldn't happen.
HTH,
Paul Ibison

[quoted text, click to view]

RE: Distributor Agent

rboyd NO[at]SPAM onlinemicrosoft.com
2/9/2004 8:06:37 PM

Use sp_browsereplcmds at the distributor to find the exact command that is
failing. Verify that the row is at the subscriber. You can then delete teh
row at the subscriber and restart the distribution agent.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.