IDENTITY_INSERT 2

[grnzbra]

I have the following code which results in an error message saying I can't insert a value in an identity column unless IDENTITY_INSERT is ON. It seems to match the example given for IDENTITY_INSERT. What might the problem be?

SET IDENTITY_INSERT CMMSSrc.dbo.rtblChecklistSeed ON					
INSERT INTO CMMSSrc.dbo.rtblChecklistSeed
SELECT * FROM GMMS_WorkOrders_Linds_Test.dbo.rtblChecklistSeed
WHERE fldPostKey = @OrgUnitKey
SET IDENTITY_INSERT CMMSSrc.dbo.rtblChecklistSeed OFF	
SELECT * FROM CMMSSrc.dbo.rtblChecklistSeed

 

[MarkSweetland]

You need to specify the particular columns for the insert:

INSERT INTO CMMSSrc.dbo.rtblChecklistSeed(columnName1, columnName2, etc...)

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[grnzbra]

Thank you. That did it.