October 25, 2007 at 7:19 pm
I have two servers (server A and server B) which i want to replicate. I made server A as a publisher and server B as subscriber im also using snapshot replication (since i cant use transactional because not all tables have PK, Merge replication is also out of the option since we will only update server A making server B only a backup of server A) the snapshot runs smoothly completed successfully but when i try to synchronize server A with server B it displayed an error stating "Invalid column S" i tried restoring the database on both server in displayed an error message again stating "Invalid column U" somtimes the error says "Invalid column R". I dont understand the error message since i dont have a table column name "S","R","U". any have encountered this error before? any knows any possible solutions?? thanks in advance...
"-=Still Learning=-"
Lester Policarpio
October 29, 2007 at 6:38 pm
Got the answer now in microsoft support for those who have the same problem here is the llink of why this is happening in replication
http://support.microsoft.com/kb/832902
"-=Still Learning=-"
Lester Policarpio
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply