May 22, 2003 at 7:51 am
We are using SQL Server 2000. We are facing quite a few problems while implementing transactional replication.
1. Triggers are replicated with quoted string as the name of the trigger in the replicated database e.g. a trigger with test is replicated as "test" - though it is not creating any problem, we found normally we can't create a trigger with a name like "test".
2. For some of the tables Triggers are not replicated at all.
3. In tables with triggers, which updates one of the field of the trigger table only after doing some specific operation in some other tables - primary to secondary replication is working fine but secondary to primary - it is generating conflict errors and rollbacking the transaction mentioning "primary wins".
Regards,
Amit Khan
Ontrack Systems Limited
276B Lake Gardens
Kolkata - 700045
India
Phone - 91-33-24178434,35
Fax - 91-33-24221274
Mobile - 91-33-9830105090
Regards,
Amit Khan
Ontrack Systems Limited
276B Lake Gardens
Kolkata - 700045
India
Phone - 91-33-24178434,35
Fax - 91-33-24221274
Mobile - 91-33-9830105090
May 26, 2003 at 12:00 pm
This was removed by the editor as SPAM
May 27, 2003 at 9:19 am
if anybody is interested to take it up, I can send you a test database dump. please contact me at amit@ontrackindia.com or amit_khan77@yahoo.com
Regards,
Amit Khan
Ontrack Systems Limited
276B Lake Gardens
Kolkata - 700045
India
Phone - 91-33-24178434,35
Fax - 91-33-24221274
Mobile - 91-33-9830105090
Regards,
Amit Khan
Ontrack Systems Limited
276B Lake Gardens
Kolkata - 700045
India
Phone - 91-33-24178434,35
Fax - 91-33-24221274
Mobile - 91-33-9830105090
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply