Web-automation.ru

Решение:

использование
SET IDENTITY_INSERT testIdentity ON;
USAGE-HOW-TO:
CREATE TABLE testIdentity (id int IDENTITY (1,1), name nvarchar(100));
INSERT INTO testIdentity(name) VALUES ('name1'); e Row will be (1, name1)
INSERT INTO testIdentity(name) VALUES ('name2'); e Row will be (2, name2)
SET IDENTITY_INSERT testIdentity ON;
INSERT INTO testIdentity (id, name) VALUES (10, 'name10'); e Row will be (10, name10)
INSERT INTO testIdentity (id, name) VALUES (20, 'name20'); e Row will be (20, name20)
SET IDENTITY_INSERT testIdentity OFF;
INSERT INTO testIdentity(name) VALUES ('name??'); e Row will be (3, name??)