April 11, 2011 at 8:43 am
Hello
I have set up replication of an existing large database in our system. I am setting it up as one way pull transactional replication initialised from a backup. I have created the publisher and the subscriber but I am getting an error when trying to replicate identity columns. The error is as follows
Explicit value must be specified for identity column in table 'audits' 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)
Get help: http://help/545
I have found some information reguarding identity columns but I am having trouble making sense of it, basically what i want to do is have a main box, and a replicated box used for reporting. Ideally I want the replicated reporting box to have identical data to the live box, does the option NOT FOR REPLICATION mean identity values will be inserted in the replicated table with the exact same value as the main table?
Anyone completed this kind of thing before out there could help me out???
Cheers
April 13, 2011 at 9:41 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply