What they mean is that the distributor will work with versions of SQL Server 2 up or 2 down from the distributor.

With that said, I have had 2000 publishers going...

There is not a direct upgrade path from 2000 to 2014, and yes it is a painful experience made even more complicated and painful if you have replication running.

I had...

I have been away for awhile, and am slowly coming back. So I have started on QOD's again to catch up. Lots to go 😉

IMHO the B answer is the...

I don't think transactional replication is going to do it for you. Maybe merge. But those identity fields are going to kill you.

If the data is going one way, from DB A to DB B and not going the other way the change the tables using identity fields by dropping the identity...

"works well under pressure – our management team considers everything urgent and is going to micro-manage you daily."

and the DBA team and developers and network people combined:-D

I read in amazement some of the answers on here. I agree to a point with someone who posted earlier about arrogance. There are people who in the past had...

Did you modify the Article Properties when you created the publication? There is a place where you can tell it to not replicate deletes in the statement delivery section.

One other thing, are you replicating deletes? you could get the duplicate index error if you delete a record and reinsert it on the publication side. The delete would not...

Without the schemas of at least the table(s) you are talking about, I suspect that there is a unique index on the subscriber that is not on the publisher. This...

Based upon what you are showing, I would ask are both the publication and subscriber tables identical?

Please post the schemas for both as well as indexes.

Same here. Rushed a bit. Good question.

Great refresher. I have saved it for future re-reading periodical, if even to remember Atomicity. (I to forget this word.:hehe:

Exactly.

BTW I got Command(s) completed successfully.

Gail - Thanks

Lynn - you are correct on 2005. Just finished some light reading.

Just proves you never stop learning.