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