I have a 2005 database set up Ok for Merge replicataion and I need to add data from an Acess 97 database I have been using the wizard to import the tables to new tables then I have a script which appends the tables sometimes making small changes this
is fine if the database is not replicable but will not work if it is. I do need to keep all identiy fields
Some of these tables only have a couple of rows and their 'range' seems to be within the values in the table properties
I get error
The insert failed. It conflicted with an identity range check constraint in database 'My_MPC', replicated table 'dbo.TblLiqItems', column 'LiqId'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher,
execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.
jnc
View Complete Post