create table identicheck( checkid int identity(1,1) primary key, checktext varchar(20) )
insert into identicheck(checktext) SELECT 'one'
set identity_insert identicheck on
insert into identicheck(checkid,checktext) SELECT 3,'three'
set identity_insert identicheck off

dbcc checkident(identicheck) --returns 3

dbcc checkident(identicheck,RESEED,1) --sets to 1

insert into identicheck(checktext) SELECT 'next' --inserts the value 2
insert into identicheck(checktext) SELECT 'next'  --should insert the value 3, crashes
select * from identicheck

drop table identicheck