Showing posts with label sp4could. Show all posts
Showing posts with label sp4could. Show all posts

Wednesday, March 21, 2012

Replication problem with begin transaction

SQL Server 2000 sp4
Could you feed me about replication problem when using
begin transaction and
commit transaction command ?
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...
>
|||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...
>
sql