When I try using the "insert into select from"....for some of my tables I get this error:

An explicit value for the identity column in table 'db1' can only be specified when a column list is used and IDENTITY_INSERT is ON

i got some help frm google.
SET IDENTITY_INSERT YourTable ON

INSERT INTO YourTable
SELECT * FROM YourOtherTable

SET IDENTITY_INSERT YourTable OFF


i used it bt again error comes as syntax error for both lines ON/OFF
wht does it mean by" IDENTITY_INSERT is ON"


wht to do?
thanks in advance