• My question would be, why you want this behavior especially on the primary key which is having an Identity? Why you want to avoid gaps in a identity???