@ypercubeᵀᴹ If it ain't broke, don't fix it.

@Colin'tHart yeah. It's going to be state of the art again, in 78 years.

Windows (20)95

@ypercubeᵀᴹ until the first one commits

when the first one rolls back, the second succeeds

@dezso yes, but I haven't managed to get the serialization error

I'll setup a profiler to catch all queries sent to the database, to find what is really happening.

My gues sis some other transaction does an update on that or another table

without FOR UPDATE

@dezso when the 1st one commits, the 2nd gets unblocked, too. and succeeds if it commits

@JakeFeasel are you still on Skype? I tried contacting you back in Feb — I just assumed work had got too busy.

Hypothetical question: if SQL Server source code leaked the way Windows 10 source code did, what would be the first thing you looked at?