Identity columns cannot be updated by the application. The identity column of a table is under the control of the database.

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Identity columns cannot be updated by the application. The identity column of a table is under the control of the database.
Document ID : 000-000787 Created: 4/08/2003 Last changed on: 4/08/2003
Applies to : MS SQL server

Your station has specifically attempted to alter the value of an identity column in the SET portion of the UPDATE statement. You can only use the identity column in the WHERE clause of the UPDATE statement.

This error indicates that there is either an error in the NetKeeper database layout or the communication link between NetKeeper and the back-end is corrupting generating errors and damaging the SQL (or ODBC) messages sent to the server. NetKeeper applications do not update the identity value.

This can be a difficult problem to troubleshoot. Use the SQL server utilities to see the query at the server and compare the query with the query sent by the workstation. To view the query sent by the workstation you need specialized tools that display the data sent to the SQL server.

Installing the newest network drivers and the most recent SQL clients and patches on your workstation often fixes this type of problem.

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.