Post reply

Identity_Insert in Replication

  • April 3, 2009 at 2:59 pm

    #201785

    we have a transactional replication setup between 2 sql 2005 servers....I got replication failure message like

    Explicit value must be specified for identity column in table 'tblabcd' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column. (Source: MSSQLServer, Error number: 545)

    When I start synchronising the replication, it is getting failed again and again....how can I fix this error in replication?? Please help me out...

    Thank you

  • April 5, 2009 at 11:48 pm

    #972289

    What I do is create the table in the subscriber with the ID column as an INT or BigINT and then set up the replication. Then I never have that problem.

    -Roy

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

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