General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
IDENTITY_INSERT is set to OFF
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only