IDENTITY_INSERT??

[csiwa28]

I am trying to write to a SQL database and I received the following error:


"Cannot insert explicit value for identity column in table 'members' when IDENTITY_INSERT is set to OFF"


What exactly is IDENTITY_INSERT and i'm assuming i would need to turn it on. How would I go about doing so. Any help would be greatly appreciated.

 

[KCWMS]

from SQL SERVER BOOKS ONLINE
SET IDENTITY_INSERT
Allows explicit values to be inserted into the identity column of a table.

This allows you to manually add a value to a collumn defined as an IDENTITY/auto-incrementing column (one that SQL SERVER will fill automatically). Generally you don't want to do this... but yes you would have to turn IDENTITY_INSERT on before executing any sql and then turn if off when done.

 

[csiwa28]

So it's like the autonumber field in Access correct?

 

[KCWMS]

Exactly.