>>1. Use the "UniqueIdentifier" data type within SQL Server and the "Identity Increment" property. The problem lies in ensuring that I return a GUARANTEED unique record id.

Actually UniqueIdentifier datatype and NewID() are only avilable in SQL Server 7.0... your heading says 6.5 but you mentioned the UniquId Type which was added in 7.0 .

BOb