Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cannot insert explicit value for identity column in table x

 
   Database Help (Home) -> Replication RSS
Next:  cannot seem to delete SSAS database  
Author Message
CindyB

External


Since: Mar 16, 2010
Posts: 1



(Msg. 1) Posted: Tue Mar 16, 2010 12:49 pm
Post subject: Cannot insert explicit value for identity column in table x
Archived from groups: microsoft>public>sqlserver>replication (more info?)

I am reposting this from the Sql Server Forum.

We are using Sql Server 2005 9.00.4035.
We have a hub and spoke topology which includes 6 tables with identity
columns.
I need to add a new subscription to a new server (same version/sp). I took
backup from another subscriber and restored to new server, ran snapshot, push
subscription. To make sure a new record would replicate, I added a record at
the publisher with the followig text:
Insert into tblicimagefolder (imagefolder) values ('dummy')

A conflict occurs with the following: This failure can be caused by a
constraint violation. Cannot insert explicit value for identity column in
table tblicimagefolder when identity insert is set to off.

I do not want to turn the identity insert off because I want the system to
assign the value.

I let the merge agent run to one of the existing subscribers and the data
was added without conflict.

Any suggestions?

Thank you for any help in advance.

--
CindyB

 >> Stay informed about: Cannot insert explicit value for identity column in table x 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Replication- Identity column cause error - Dear all, I use merge replication with central subscriber topology ( 1 subscriber and 2 publishers), 2 Publisher is also distributor and subscriber is the database I need to tranfer data to. I have 2 tables: Order ( using identity -primary key with..

P2P Replication and the identity column - Hi, Im putting a plan together to replicate my SQL server on 2 different sites. What i am wondering is i know i can have it so rows can be updated on one server and the other is updated and so forth but if i was to say insert a row into a table on..

identity column in Merge replication. - I need to replicate a table with a identity column as the primary key. I would like the two tables (publisher side and subscriber side) to have different seeds. The problem is: If I choose to initialize during the creation of the subscribtion, the tabl...

SQL2000: Unable to insert into repliacted table - Hi NG We have a Merge replication (SQL2000). For no apparent reason, inserts into the replicated tables have suddenly stopped working. I have done a DBCC REINDEX on all the tables/indexes, with no change. Tables contain approx 12 million records. ...

Adding a column to a replicated table - What are the restrictions on modifying the structure of a replicated table? I have added columns in the past and synchronised clients after the modification and the modifications seem to have been picked up OK (on the clients). However, I have also..
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]