Is it possible that your incoming data is too long for for your varchar PK and is getting truncated?

for example

001401926 becomes 0014 and you get a duplicate pk value

Just out of interest... is this an update proc or a select proc?

from what I've read, you need to script out your publications and subscriptions then - here's the uncomfortable bit, disable replication, DELETE the distribution database , then rebuild the distributor...

to find out how many recursions then put an int as your anchor, then keep incrementing it

something like this (I copied and pasted from another site)

WITH   cte

AS     (SELECT 1 AS...

i'll save you the time searching

https://www.bcs.org/get-qualified/certifications-for-professionals/software-testing-certifications/istqb-certified-tester-foundation-level/

there are test exams and answers - maybe a bit much without coaching, but its a starting point for you

happy to help

if you are looking at docker and kubernetes and you are thinking about using amazon aws then start looking at AWS fargate

pulling together?

Our bosses (here) are pushing us together - but with no official policy (in a good way)

I asked my boss (i'm quoting verbatim)  "what do you want me to...

In 20 years of using SQL Server, I've never dealt with a QA team just for T-SQL code.  What exactly should that team be testing and how?

And I don't...

It has mirroring on it? that explains it the mirror will be using transactions to send to the secondary

why are you using replication and mirroring on the same server?

Thank you all.

Thank you all for your responses. Now that I've reviewed, I think I need to add more information.

1. The SQL developers build their code. These are usually,...

what time zone are you in ? - just to understand start time : Mar 11 2020 2:50:58:403PM

since it is currently 14:17 in the uk - maybe the better question...

have you run a dbcc opentran against the database to see if there is an open uncommitted transaction?

also triggers on the tables you want to replicate ?- if so do...

even better - put some default values against the parameters just in case someone doesn't know to pass a parameter.. but get it to log those executions

but empty aircraft - that's a lot of fuel dumped into the atmosphere - maybe regulators might look at that idea and pay operators to not fly unnecessary...