Posted by Gert-Jan Strik on 08/18/07 13:39

Check out "DBCC CHECKIDENT" in BOL.

Gert-Jan


"Bill E." wrote:
>
> SQL Server 2005
>
> We have a table where the current identity value is lower than the
> maximum value. This is the first time I've seen such a thing. How
> can this occur? I see postings about this problem but they seem to
> concern older versions of SQL Server.
>
> I did some tests on another table to see if I could reproduce the
> problem by setting Identity_Insert on and then forcing the identity to
> a value. I then set Identity_Insert off and added a row normally, but
> the next identity was always the next largest number, not some number
> in between.
>
> Bill E.
> Hollywood, FL

• Next in forum: How to check if a Table is <empty> ie doesnt contain any rows
• Prev in forum: Re: Unaccountable jump in Identity column value
• Thread view: Re: Inconsistent identity values

[Reply to this message]