Unless you create your primary key with FOR NOT Deleted(), you cannot enter a duplicate primary key even if the other one is deleted.

If you go with the FOR NOT Deleted() condition, dont forget to add a second regular index in the field that Rushmore could use (Rushmore will not use a filtered index). Dont forget to plan a recovery method in the case that a deleted record is recalled and a duplicate exist.

HTH

>Is it really like this?
>If I have a record with the ident (which is a unique index) = 1000, I deleted it, I cannot put 1000 anymore?