>>>>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.

Yes, I do use CAs. And the field is not in the UpdateableFieldList. And I even tested the same program on my computer with my copy of the SQL Server and it worked (no error). So it must have been something that happened in the customer database or session that caused the program. I am waiting now for him to call me back so that I could ask him to try inserting a record again.