Add id manually in column with Identity and reset seed value

sql_reset_seed_value.sql

--http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server

SET IDENTITY_INSERT IdentityTable ON 

INSERT IdentityTable(TheIdentity, TheValue) VALUES (3, 'First Row') 

SET IDENTITY_INSERT IdentityTable OFF 

--Note that the next value will be whatever you reseed with + 1, so in this case I set it to 10 so that the next value will be 11.
--This SEED should get updated itself if any Id higher than the seed is used
DBCC CHECKIDENT (IdentityTable, RESEED, 10) --Reset seed value