Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SNAPSHOT REPLICATION NOT EFFECTING TRIGGERS ??? HELP !!!!!

Status
Not open for further replies.

mooki

Programmer
Aug 1, 2000
32
IL
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top