>>Yes, you can: filter your primary key index on NOT DELETED(), and deleted records won't bother you. However, this has a drawback; since filtered indices won't be used by Rushmore, you will need to add a
regular index on the same expression, so your queries can be optimised.
>>
>Uhhh! Are you sure about this? My experience is that a deleted record still will not permit a new record with the same primary key to be added to the table irrespective of SET DELETED status.
>
>regards,
SET DELETED and INDEX ON FOR DELETED() are two different issues. You are correct that SET DELETED will still prohibit the reuse of a primary key. INDEX ON FOR DELETED() will not.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer