Sunday, March 11, 2012

Can default Isolation Level be changed?

Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.No, you will have to change it at the connection level.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sydney Delieu" <syddel@.hotmail.com> wrote in message
news:OzlpNXxLEHA.1156@.TK2MSFTNGP09.phx.gbl...
Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.

No comments:

Post a Comment