SET IDENTITY_INSERT OFF INSERT INTO table1 (ID, Field1) VALUES (6,'test') SET IDENTITY_INSERT ON
DBCC CHECKIDENT (yourtable, reseed, 5)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)