anbillava (12/29/2008)
There are different instance of generating id.. Most of which i can replace by identity. But in one case a random number will created by one of method and also it checks in the database to see the random number is previously created.
I don't see any practical way that you can archive those random ID's. You cannot check for a conflict if they are not in the database anymore.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]