|
Subject:
|
Replication and Triggers comibnation
|
|
Posted By:
|
RRNP
|
Post Date:
|
9/23/2004 2:36:24 PM
|
Dear Friends,
I have created the transactional replication between two servers.I have a few triggers on the subscription database.These triggers are very simple, just I am updating the timestamp column in the subscription database whenever, the record is getting inserted or updated to this database thru the replication.
My problem is, whenver I am running this transactional replication process against to the large volume(say approx 1crore records) of tables, the SQL replication agent is throwing a time out exprie error.If I remove the triggers, this agent is working fine.The same replication process with triggers is working fine against to the small volume of tables.
Pls revert back to me if you haven't understand the problem.
I will appreciate if any one can help me, to come out from this problem.
Regards,
RRNP
|
|
Reply By:
|
dhay1999
|
Reply Date:
|
9/23/2004 2:50:32 PM
|
wouldn't the change on insert send another transaction back to the source database? or is this a one way transaction?
|
|
Reply By:
|
RRNP
|
Reply Date:
|
9/27/2004 8:23:24 AM
|
quote:
Originally posted by dhay1999
wouldn't the change on insert send another transaction back to the source database? or is this a one way transaction?
Hi,
Thanks for your reply.Actually I didn't get what you are trying to convey.
Can pls give me more light to it.
Once again thanks for your reply.
Regards,
RRNP
|
