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 |
|
carlosmonteiro
Starting Member
1 Post |
 Posted - 2001-11-21 : 11:09:21
|
| Hi to All(excuse but I’m a Brazilian and my English is bad)I have 2 servers, call them SQL1 and SQL2.SQL1 is a publisher and distributor, running NT4sp6a/SQL7Sp3 SQL2 is a subscriber publications Transactional Replication with Immediate Updating Subscribers is used to replicate publications to SQL2(and vice-versa)I have 3 problems:1 – I have triggers in SQL1 and I like replicate this triggers. I do this manually(any other idea?).2 - Manually replication for the triggers force me exclude the the following code from replication's triggers(ins, up an del) to no errors occur:" if Objectproperty(@@procid,'TriggerInsertOrder') != 1 begin raiserror (21128, 16, 1) return end"3 – The new rows in the publisher are not replicate to subscriber. After this, the follow message appear in the subscriber when I attempt insert new rows:“Updatable Subscribers: Rows do not match between Publisher and Subscriber. Refresh rows at Subscriber.”Any help I will to thank.Carlos Monteiro |
|
|
|
|
|
Problems withTransactional Replication