| Author |
Replication problem with begin transaction
|
|
|
| SQL Server 2000 sp4
Could you feed me about replication problem when using
begin transaction and
commit transaction command ???
| |
| Hilary Cotter 2005-07-19, 7:24 am |
| what is the exact error message and number you are getting?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rl" <rlavoie@lgs.com> wrote in message
news:eqE6fy8iFHA.320@TK2MSFTNGP09.phx.gbl...
> SQL Server 2000 sp4
>
> Could you feed me about replication problem when using
> begin transaction and
> commit transaction command ???
>
>
>
| |
|
| Ok let me explain my real problem
I update table abc to SERVER A
SERVER A push a replication to SERVER B
and SERVER B push to SERVER A and SERVER C
SERVER A and C are configure to replicate to SERVER B and
SERVER B is configure to replicate to SERVER A and SERVER C
(same tables are replicate)
I have no problem while I not use BEGIN TRANSACTION UPDATE... COMMIT
TRANSACTION
When I use BEGIN TRANSACTION UPDATE... COMMIT TRANSACTION I got a conflict
error
------------------------------------
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23hRaQeFjFHA.2444@tk2msftngp13.phx.gbl...
> what is the exact error message and number you are getting?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "rl" <rlavoie@lgs.com> wrote in message
> news:eqE6fy8iFHA.320@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Hilary Cotter 2005-07-19, 1:23 pm |
| What form of replication are you using?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rl" <rlavoie@lgs.com> wrote in message
news:eVepVEGjFHA.576@tk2msftngp13.phx.gbl...
> Ok let me explain my real problem
>
> I update table abc to SERVER A
> SERVER A push a replication to SERVER B
> and SERVER B push to SERVER A and SERVER C
>
> SERVER A and C are configure to replicate to SERVER B and
> SERVER B is configure to replicate to SERVER A and SERVER C
> (same tables are replicate)
>
> I have no problem while I not use BEGIN TRANSACTION UPDATE... COMMIT
> TRANSACTION
>
> When I use BEGIN TRANSACTION UPDATE... COMMIT TRANSACTION I got a conflict
> error
> ------------------------------------
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:%23hRaQeFjFHA.2444@tk2msftngp13.phx.gbl...
>
>
| |
|
| transactional
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:uMvy4dIjFHA.3608@TK2MSFTNGP12.phx.gbl...
> What form of replication are you using?
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "rl" <rlavoie@lgs.com> wrote in message
> news:eVepVEGjFHA.576@tk2msftngp13.phx.gbl...
>
>
|
|
|
|