-
Triggers in Replication
Hi,
I created a database trigger to monitor changes made to a particular column in a table. My problem now is there is a request to add this trigger into a replicated environment. For example: Database A is replicated to Database B on a daily basis. I need to add this trigger into Database A and make sure the information from that trigger is replicated over to Database B as well.
My question is:(please bear with me, I have not done replication of database before)
1)Can I simply add a trigger into a database and not affect it's current setting.
2)How can I do this replication of the trigger info thing.
3)Can it work if I add a trigger in Database A and add another trigger in Database B?
Please assist.
Regards,
MK
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|