Easy one this, if you're trying to insert rows with specific values to go into an identity column (e.g. when transferring data from one database to another) you need to use the following kind of statement
SET IDENTITY_INSERT tablename ON
INSERT INTO tablename (column1, column2)
SELECT column1, column2 FROM table2
SET IDENTITY_INSERT tablename OFF