Thursday, March 29, 2012

change isolation level server wide

Just curious to know how one can change isolation level server wide ? I know
the default is read committed but if i wanted any other isolation level, how
may one do so ? Using SQL 2000
Hi Hassan
Unfortunately, there is no way to do this server wide. It must be set in
each connection for which you want to change from the default.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uxGOCqebEHA.3684@.TK2MSFTNGP09.phx.gbl...
> Just curious to know how one can change isolation level server wide ? I
know
> the default is read committed but if i wanted any other isolation level,
how
> may one do so ? Using SQL 2000
>
|||You can only change it at session level, using the SET TRANSACTION ISOLATION
LEVEL command.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uxGOCqebEHA.3684@.TK2MSFTNGP09.phx.gbl...
Just curious to know how one can change isolation level server wide ? I know
the default is read committed but if i wanted any other isolation level, how
may one do so ? Using SQL 2000

No comments:

Post a Comment