November 17, 2003 at 8:09 am
Hello, I am setting up new transactional replication. It stops at particular table by saying
Error 2705: Column names in each table muct be unique. Column name say(reason_code) in table say(table1) is specified more than once. Cannot ROLLBACK sp_MSmakeconflicttable.
No transaction or savepoint of that name was found.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION is missing. Previous count = 0, current count = 1. sp_MSMakeconflicttable(debug). xp_execresultset failed.
Please help me. THANKS.
November 20, 2003 at 8:00 am
This was removed by the editor as SPAM
November 20, 2003 at 8:32 am
Havent seen that before. Tried backing up and starting from scratch? You're doing plain transactional, no queued or immediate updates?
Andy
November 20, 2003 at 9:04 am
Thanks for looking into it. I am still having this problem, I don't know why? This 1 table is the only one giving me problem. I will try again and see if I find any solution. I will update here. Thanks.
December 3, 2003 at 11:09 am
I resolved this issue. Problem was, when replication creates conflict table it creates a column called 'reason_code' and I was trying to publish a table which already has this column name. I renamed the column and now everything is fine.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy