 <p>To insert ID value on a table just do that</p> <pre><code>SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF } </code></pre> <p>Example your table name is People it should be</p> <pre><code>INSERT INTO People(ID,NAME) VALUES(3,'Felicio') </code></pre> <p>PS: to insert indentity value you also need to explicity the columns names and order as in previous example.</p>