I have a stored procedure which uses IDENT_CURRENT
to update last added value in a table.
The issue is:
IDENT_CURRENT
returns a value that does not exist in the table.
The number it returns is much higher than Max(ID) of the table.
How is it possible and what can be done to fix it. I never wanted to use MAX(ID)
to update the table.
Thanks.