Has anyone here seen this?  Does anybody have any additional info?


Statement-Level Snapshot which maps to Repeatable Read for Oracle. This is
the most common Isolation level for Oracle applications. (ALTER DATABASE
<db> SET READ_COMMITTED_SNAPSHOT ON)
Transaction-Level Snapshot which maps to Serializeable for Oracle. (ALTER
DATABASE <db> SET ALLOW_SNAPSHOT_ISOLATION ON)

Full story at the link below:

http://tinyurl.com/5mz47

Jason wrote:

> Has anyone here seen this?  Does anybody have any additional info?
> 
> 
> Statement-Level Snapshot which maps to Repeatable Read for Oracle. This is
> the most common Isolation level for Oracle applications. (ALTER DATABASE
> <db> SET READ_COMMITTED_SNAPSHOT ON)
> Transaction-Level Snapshot which maps to Serializeable for Oracle. (ALTER
> DATABASE <db> SET ALLOW_SNAPSHOT_ISOLATION ON)
> 
> Full story at the link below:
> 
> http://tinyurl.com/5mz47

They have been desperately working to achieve this. But the statement
that "The good new is SQL Server 2005 solves this." is a bit of
misdirection as the product does not exist.

One also has to wonder whether, like row level locking, they have
implemented a minimalist version just so that they can make the
marketing claim.

-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)