Hi,
I am using Snapshot replication from one server to another.
on Target i have triggers that copies all replicated information to 3rd table! BUT : apparently the triggers are effective ONLY with Merge agent and not with SNAPSHOT agent.
i saw on profiler that the snapshot is using BULK INSERT and not usual insert.
QUESTIONS :
1) Is there a way to direct the snapshot replication to use
the Triggers ??
2) Is there any way to run from Server A a stored
procedure that is located on Server B ???
(i will do the copy to the 3rd table over there)
I Would appreciate your Immediate Help about it.
Thanx.
I am using Snapshot replication from one server to another.
on Target i have triggers that copies all replicated information to 3rd table! BUT : apparently the triggers are effective ONLY with Merge agent and not with SNAPSHOT agent.
i saw on profiler that the snapshot is using BULK INSERT and not usual insert.
QUESTIONS :
1) Is there a way to direct the snapshot replication to use
the Triggers ??
2) Is there any way to run from Server A a stored
procedure that is located on Server B ???
(i will do the copy to the 3rd table over there)
I Would appreciate your Immediate Help about it.
Thanx.