>>How safe is it to use sys(2015) to generate unique ids for table records. Is >there a high probability of duplication of ids?
>>
>>David
>
>Not if its a single user application.
>Add more users, and you'll increase your odds.
>
>Is there any reason your not maintaining your own unique id counter?
In addition, I believe SYS(2015) will eventually give non-unique values. Sometime in November a year or two ago, the algorithm flipped over, and the values started repeating. SYS(2015) is documented to be used with procedure names, and Microsoft does not recommend using it to generate keys.
Mike Stewart