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