INSERT identity

On Jun 18, 3:53 pm, "David Chase" wrote:
> If I issue a command to insert a record with ALLOW IDENTITY INSERT will I
> have to reset the current IDENTITY column?  Thanks.
>
> David

if allow identity insert and your table is as follows:

ID Desc
========
1 aaa
2 bbb
3 ccc

...and you insert values(5,'ddd'). when you turn identity insert off,
the next available ID will 6.