Thank you. Had a look before posting the original question but it did not help (even tried read uncomitted...).

Each insert into the parent table (Saar) causes two locks (per session): Row lock (RID) and Index (key), so we have 2 RID and 2 KEY locks all granted.

Now when...

Thanks, but this is causing an issue as I do not want the first insert to complete if the 2nd fails (for example).

I have found that if the 2nd insert...