Post reply

QOD for Nov 16

  • November 16, 2004 at 12:49 am

    #108748

    Can't find the admin created thread so...

    Today's question reads

    "You have a SQL 2000 transactional publication that has a failing distribution agent, the error message indicates that it is because it attempted to insert a duplicate primary key on the publisher."

    The distribution agent doesn't do inserts on the publisher, it does inserts on the subscriber, hence none of the options given are valid.

    Should that read "it attempted to insert a duplicate primary key on the subscriber"?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 16, 2004 at 10:01 am

    #530306

    good catch, it's corrected.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • November 16, 2005 at 5:10 am

    #604148

    Hi Steve

    Can you tell us how it got corrected? we are facing same problem in SQL Server 6.5

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply