@TLBH said:i meant using the both nk and an identity AS the pk - meaning you can insert the same nk twice.. THAT is broken.Unless the natural key is not as unique as it should be, which happens more often than you expect.