Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gsuttie
Starting Member
14 Posts |
 Posted - 2009-07-17 : 07:06:40
|
| Hi There I have a table which is required to be replicated to another server database at a different location - If i try to delete a row for example while the subscriber agent is synchronizing i get an error saying that I'm not allowed to do this (sorry dont have exact wording) - is this even possible or is there a setting I have missed?Greg |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-07-17 : 11:36:09
|
| Do you have triggers set? |
 |
|
|
Gsuttie
Starting Member
14 Posts |
Posted - 2009-07-20 : 11:01:26
|
| Hi there, yeah we do - I figured out the problem was related to the snapshot still being taken. If I have a table which is part of a merge replication will the triggers be dropped and then recreated as part of the merge replication - ideally I want a trigger on the subscriber db only but cant figure out how to do this - any advice?ThanksGreg |
|
|
|
|
|
|
Merge Replication help