Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET IDENTITY ON and OFF
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01545210
Message ID:
01545213
Views:
34
This message has been marked as a message which has helped to the initial question of the thread.
>>>Hi,
>>>
>>>First time this morning I get an error (actually customer does) when on inserting of a new records the error is
>>>
>>>Cannot insert explicit value for identity column in table 'tableName' when IDENTITY_INSERT is set to OFF
>>>
>>>
>>>I Googled this and found a MSFT msdn page that describes that only one table in a session can have SET IDENTITY_ INSERT ON. I have not had to "deal" with this from my VFP application so far. So my question is, do I need to do something in the VFP application on every insert? That is, do I need to send an explicit command to the SQL Server?
>>>What else could be causing this problem, kind of, all of a sudden?
>>>TIA.
>>
>>Just make sure that you didn't touch that field anywhere in your statements.
>
>I thought I didn't. And I will recheck. Thank you.

If you are using CAs, just make sure that this field is not listed in "UpdatableFieldList" property.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform