How to turn off identity for a database column of a table

If I understand you correctly, try this one -

SET IDENTITY_INSERT <your_table> ON

INSERT INTO ... (ID, ...)

SET IDENTITY_INSERT <your_table> OFF

Use SET IDENTITY_INSERT as described here