Cannot insert explicit value for identity column
in [Replication]
|
Prev: Could not load the DLL xprepl.dll
Next: SQL 2000 (the process is running and wating for a response from one of the backend connections)
From: Sandeep Shankar on 16 Nov 2007 22:13 SQL Server 2000 SP4 (Enterprise edition) both publisher and Subscriber. I have setup Identity column 'Not for Replication' in subscriber. My error is Cannot insert explicit value for identity column in table 'tablename' when IDENTITY_INSERT is set to OFF. I ran SET IDENTITY_INSERT 'tablename' ON I am still getting same error. Pl help TIA Sandeep
From: Sandeep Shankar on 16 Nov 2007 22:23
I am running transactional replication. -- Thanks, Sandeep "Sandeep Shankar" <sandeep(a)discussions.microsoft.com> wrote in message news:%23yzPifMKIHA.1208(a)TK2MSFTNGP03.phx.gbl... > SQL Server 2000 SP4 (Enterprise edition) both publisher and Subscriber. > > I have setup Identity column 'Not for Replication' in subscriber. > > My error is > > > Cannot insert explicit value for identity column in table 'tablename' when > IDENTITY_INSERT is set to OFF. > > > I ran > > SET IDENTITY_INSERT 'tablename' ON > > > I am still getting same error. Pl help > > TIA > > Sandeep > > |