"Distributed transactions only allowed Serializable isolation level" - is that true?
- From: "SammyBar" <sammybar@xxxxxxxxx>
- Date: Mon, 25 Jul 2005 09:55:32 -0500
Hi all,
We have a client-server legacy application running without major problems
for years. The server have been SQL Server 2000 SP3. As soon the client
application opens a connection it commands "SET TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED" to cope with db blockings.
Now we are starting to deploy some applications that use distributed
transaction that runs between the old server an a new one, also SQL Server
2000 SP3. We declare the same for the isolation level, but the behaviour we
observe and the blockings we get made us suspect the isolation level for
these distributed transactions is not "read uncommitteed". Googling around I
found this assertion:
"Distributed transactions only allowed Serializable isolation level"
(http://codebetter.com/blogs/sahil.malik/archive/2004/12/06/35314.aspx)
Is that true?
Thanks in advance
Sammy
.
- Prev by Date: bulk copy functions - Gathering error description
- Next by Date: RE: Remote Connection Problems via Cisco VPN over high speed internet.
- Previous by thread: bulk copy functions - Gathering error description
- Next by thread: RE: Remote Connection Problems via Cisco VPN over high speed internet.
- Index(es):
Relevant Pages
|
Loading
