|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
19/05/2008, 16h55
|
#1 |
Messages: n/a
Hébergeur: |
Isolation Level in NON-Transaction Selects
I need to set the Isolation Level (in ADO) for the Non-transaction queries to SNAPSHOT. Both the ADO.Connection.IsolationLevel Property and the SQL Server SET TRANSACTION ISOLATION LEVEL command set the Isolation Level for the Transaction queries but no for the non-transaction queries. I cannot use the READ_COMMITTED_SNAPSHOT database option, becaus when I am in a transaction I need the READ COMMITTED Isolation Level not the SNAPSHOT Isolation Level. I don't want to rewrite the entire code of my existing application to add (NOLOCK). Thanks, |
|
|
20/05/2008, 14h47
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Isolation Level in NON-Transaction Selects
On May 19, 10:55 am, Ariel <Ar...@discussions.microsoft.com> wrote:
> I need to set the Isolation Level (in ADO) for the Non-transaction queries > to SNAPSHOT. > > Both the ADO.Connection.IsolationLevel Property and the SQL Server SET > TRANSACTION ISOLATION LEVEL command set the Isolation Level for the > Transaction queries but no for the non-transaction queries. > > I cannot use the READ_COMMITTED_SNAPSHOT database option, becaus when I am > in a transaction I need the READ COMMITTED Isolation Level not the SNAPSHOT > Isolation Level. > > I don't want to rewrite the entire code of my existing application to add > (NOLOCK). > > Thanks, answered in microsoft.public.sqlserver.programming |
|
|
|
| Outils de la discussion | |
|
|
