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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-20 : 08:26:34
|
| Kevin Nguyen writes "I am trying to setup Transactional replication between 2 SQL 2000 servers. I set it up with the Immediate Update subscribers. I was able to setup the replication properly. When I inserted a row at the Publisher, everything would replicate fine to the subscriber. However, when I insert a new row at the subscriber, it did not replicate to the publisher (this violates the 2 phase commit theory). After some research, I executed the sp_link_publication stored procedure with security mode 0 with SA credentials. That did not help. So I execute sp_link_publication with security mode 2 and created a link to the publisher server. After this, I tried to insert a new row at the subscriber and got: “RPC to Publisher failed” …. “Transaction rollback…”I would appreciate you help on this because I am running out of options and ideas.ThanksKevin P. Nguyenknguyen@griffintravel.com" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-20 : 12:40:57
|
| There is no 2 phase commit in replication. The transaction commits, then it is sent to the subscribers. The transaction does not roll back if it cannot update the subscriber as it would in a distributed transaction(2 phase commit).-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-20 : 12:42:06
|
| Oh,Also, I have had this problem occur if I didn't do the snapshot when setting up replication. Even if I new the 2 DBs were identical, I still have had to let the replication wizard apply the snapshot.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
Immediate Updating - Transaction replication