Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jparker
Posting Yak Master
118 Posts |
 Posted - 2005-02-09 : 03:50:25
|
| I am getting the following error but I don't know how to sort it out. My table has the relevant permissions to do an insert so I am a little confused.80040E14"Cannot insert explicit value for identity column in table 'mytable' when INDENTITY_INSERT is set to OFF"Please help |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2005-02-09 : 04:28:56
|
| The error message is pretty much self-describing. Have a look in BOL for "SET IDENTITY_INSERT"You are aware that this value will cause an INT overflow?--Frankhttp://www.insidesql.de |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-02-09 : 05:10:33
|
| Identity column is auto incrementing column. You should not try to add value to that column until you set SET IDENTITY_INSERT tableName ON Madhivanan |
|
|
|
|
|
|
80040E14 - INSERT_INDENTITY problem