-
as seen on Stack Overflow
- Search for 'Stack Overflow'
When do distributed transactions make sense in a service-oriented architecture?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello!
I've a question regarding distributed transactions. Let's assume I have 3 transaction programs:
Transaction A
begin
a=read(A)
b=read(B)
c=a+b
write(C,c)
commit
Transaction B
begin
a=read(A)
a=a+1
write(A,a)
commit
Transaction C
begin
c=read(C)
c=c*2
write(A,c)
commit
So there…
>>> More
-
as seen on Programmers
- Search for 'Programmers'
I have a problem that involves several machines, message queues, and transactions. So for example a user clicks on a web page, the click sends a message to another machine which adds a payment to the user's account. There may be many thousands of clicks per second. All aspects of the transaction…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
As part of a transaction I’m modifying rows in tables via a server link, so have to specify “SET XACT_ABORT ON” in my sproc otherwise it won’t execute. Now I’m noticing that SCOPE_IDENTITY() is returning NULL, which is presumably something to do with the distributed transaction scope?
Does anyone…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi there
We're seeing the following intermittent warning logged by MSDTC:
A caller has attempted to propagate a
transaction to a remote system, but
MSDTC network DTC access is currently
disabled on machine 'X'. Please review
the MS DTC configuration settings.
However, MSDTC is disabled…
>>> More
