sql identity insert on

SQL Server IDENTITY_INSERT allows explicit values to be inserted into the identity column of a table.  

The IDENTITY_INSERT statement must be set ON to insert explicit value for identity column. By default IDENTITY_INSERT is OFF.