What is your replace (UPDATE?) command? The error seems to be pretty self-explanatory.
>Hello everyone,
>
>When I execute my REPLACE syntax this err msg occur:
>
>* -------------------------------------------------------------------------
>Connectivity error: Cannot insert explicit value for identity column in the table when IDENTITY_INSERT is set to OFF.
>* -------------------------------------------------------------------------
>
>Im using SQL 2000 as database and my only got 4 fields and only one of the is the primary:
>
>[patno] [int] IDENTITY (1, 1) NOT NULL ,
>[lastname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[firstname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>[miname] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
>
>I hope someone can help me how can I solve this err.
>
>Thank you very much.
>
>Marlon E.
If it's not broken, fix it until it is.
My Blog