Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Has anyone gotten 'Cannot insert explicit value for identity column

Status
Not open for further replies.
knetling

knetling

Programmer
Aug 14, 2003
1
US
I'm getting the error 'Cannot insert explicit value for identity column in table ... when IDENTITY_INSERT is set to off.

Does anyone know how to set it to on????
 
Sort by date Sort by votes
SET Indentity_INSERT MyTable ON

<<INSERT STATEMENY>>

SET Indentity_INSERT MyTable OFF


&quot;Shoot Me! Shoot Me NOW!!!&quot;
- Daffy Duck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
195
drlex
drlex
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
147
botatun
botatun
briangriffin
  • Locked
  • Question
Add Current Date to Insert
Replies
2
Views
80
drlex
drlex
okcorral
  • Locked
  • Question
insert in to DB2 Z/vse via SQL 2005 linked server
Replies
1
Views
168
okcorral
okcorral
mxo
  • Locked
  • Question
how to insert a line break in a datagrip column
Replies
1
Views
140
markros
markros

Part and Inventory Search

Sponsor

Back
Top