Home Forums SQL Server 2005 Administering Getting Error: Cannot update identity column RE: Getting Error: Cannot update identity column
karolanet333
SSC Rookie
Points: 25
More actions
December 2, 2010 at 8:51 am
#1257939
Hi !!! To make the sentence "SET IDENTITY_INSERT TableName ON" works
You have to write all the fields of the table in the insert sentence