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
Wednesday, March 21, 2012
Replication problem with begin transaction
Labels:
andcommit,
command,
database,
feed,
microsoft,
mysql,
oracle,
replication,
server,
sp4could,
sql,
transaction,
usingbegin
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment