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.

--
David Portas
SQL Server MVP
--

• Next in forum: Reporting Services - Crystal to SSRS
• Prev in forum: Re: How do I find the highest Unique Identifier?
• Thread view: Re: How do I find the highest Unique Identifier?

[Reply to this message]