I have an application where the newid() when hit at the same time by two users gives each use the same value. It appears to be a buffering issue with the rlock(). Any suggestions?
That's strange. I'm currently working with a shop that may have up to 75 users adding records and this doesn't happen to us.
What exactly are you doing to determine that NEWID() gives you identical Unique ID's?
Is it a possibility that your records in the ID Table are currently generating ID's that already exist? Check the PK on one of tables that uses NEWID() and compare it to what's in the ID Table.
