Iam trying to replicate from one sql server to another sql server. I have
about 25 tables to replicate. Everything is getting replicated except one.
If I include this table in the subscription list, First I will get an error
"SQL Server connection timed out.". Then in the next retry it will give
error "Attempt to insert duplicate key row in object 'tblTEMain2' with
unique index 'PK__tblUsers__0662F0A3'Failed while bulk copying into
When I check this replicated table tblUsers, all the records are copied
from source db to destination db. There is a primary key for this table.
Can anyone tell me what is going wrong here?