|
Home > Archive > MS SQL Server > October 2006 > Row-versioning Features and Compatibility Mode
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Row-versioning Features and Compatibility Mode
|
|
| Ernie Gutierrez 2006-10-24, 6:37 pm |
| I've been looking for a clear statement about whether the new
row-versioning features (snapshot isolation level and the new read
committed isolation) in SQL Server 2005 will function under
compatibility mode 80. Does anyone happen to know the answer to this
question? If so, do you know if there's an explicit statement of this
somewhere? Thanks.
| |
| Dan Guzman 2006-10-24, 6:37 pm |
| > I've been looking for a clear statement about whether the new
> row-versioning features (snapshot isolation level and the new read
> committed isolation) in SQL Server 2005 will function under
> compatibility mode 80.
Yes, SNAPSHOT is available regardless of database compatibility level.
> If so, do you know if there's an explicit statement of this
> somewhere? Thanks.
I don't know if there is one but I ran a cursory test shows it is functional
under 70 and 80. The is no mention about isolation level behavior in the
sp_dbcmptlevel topic so it would seem compatibility level is not an issue.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ernie Gutierrez" < egutierrez@relayheal
th.com> wrote in message
news:1160781728.077566.77900@k70g2000cwa.googlegroups.com...
> I've been looking for a clear statement about whether the new
> row-versioning features (snapshot isolation level and the new read
> committed isolation) in SQL Server 2005 will function under
> compatibility mode 80. Does anyone happen to know the answer to this
> question? If so, do you know if there's an explicit statement of this
> somewhere? Thanks.
>
| |
| Ernie Gutierrez 2006-10-24, 6:37 pm |
| Thanks, Dan, that's very helpful.
Dan Guzman wrote:[color=darkred
]
>
> Yes, SNAPSHOT is available regardless of database compatibility level.
>
>
> I don't know if there is one but I ran a cursory test shows it is functional
> under 70 and 80. The is no mention about isolation level behavior in the
> sp_dbcmptlevel topic so it would seem compatibility level is not an issue.
>
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
> "Ernie Gutierrez" < egutierrez@relayheal
th.com> wrote in message
> news:1160781728.077566.77900@k70g2000cwa.googlegroups.com...
|
|
|
|
|