SQL Server 2005 Replication Error

Question

Hi, i am getting replication error that says "The process could not bulk copy into table '"dbo"."tbl_name"'. The replication type i am using is Snapshot Replication and Both of my databases are SQL Server 2005 Service Pack 3.

is there any resolution to this. i happen to follow this article with no avail. http://www.mssqltips.com/sqlservertip/2063/sql-server-snapshot-replication-fails-when-importing-data-from-the-distributor/

best,

mekbeb

---

m

Answer 1

Check the schema of the tbl_name on the server as well as on the subscriber machine. This usually happens when the schemas are not matching on both sides

---

Prashanth Podduturi

Answer 2

The Schema at both end (publisher and subscriber) is the same. What else could it be?  other error if it could help

Violation of PRIMARY KEY constraint 'PK_table_name'. Cannot insert duplicate key in object 'dbo.table_name'. (Source: MSSQLServer, Error number: 2627)

Thanks in advance

---

m

Answer 3

Hi

try to reinitialize your subscriber....this happens when the schema is not identical between the publisher and the subscribe