Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction Isolation
Message
From
18/08/2007 15:43:54
 
 
To
17/08/2007 16:41:19
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01248883
Message ID:
01248965
Views:
22
Robin, Sergey answered your other question (about whether SQL SELECT statements outside a BEGIN TRANSACTION are affected by any SET ISOLATION commands), though I don't necessarily agree with his response about accounting reports.

Here's an easy way to test - open two SQL windows and issue queries and UPDATE statements against a single row in a table, and set your transaction levels accordingly. It's a quick and easy way to test behavior. Any SQL training class that covers isolation levels will use that technique.

Kevin
Previous
Reply
Map
View

Click here to load this message in the networking platform