Re: sql server 2005 -- reads no longer block rights?

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_at_x.washington.edu
(replace 'x' with 'u' to respond)