August 6, 2003 at 9:56 am
I am using one way transcational replication. Here is my problem. I have a table with a field marked as 'Staff'. I want replication to replicate these records to another table. When they reach this table I want a trigger to fire. The problem is this intial load is using bcp so the triggers won't fire. Is there anyway in replication to set bcp to fire_triggers. Thanks in advance.
August 12, 2003 at 8:00 am
This was removed by the editor as SPAM
August 12, 2003 at 10:14 am
No, you can't fire the trigger with replication during initial snapshot. But since it is a one time process, once the snapshot is applied, you can manually re-insert all the value to the table, so the trigger will fire.
Then with each transactional replication, you can have the trigger fire.
A second option (if you are using sp to replicate the commands) is to change the sp, to also insert the same records that are being sent to the original article, into the other table you also want to have replicated the commands.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply