Reply to Re: How do I find the highest Unique Identifier?
Posted by David Portas on 09/05/05 17:01
Do NOT assume that the next IDENTITY value will equal IDENT_CURRENT +
1. In a multi-user system you cannot reliably predict the next IDENTITY
value to be inserted. Nor should it be necessary to do so.
Stacey, if you explain your requirement fully I'm sure we can help you
with a better solution.