Wednesday, March 7, 2012

How to set isolation level permanently in sql server and how to check

Hi,
How to set isolation level permanently in sql server
and how to check my currenct isolation level?
Thank you
regards,
florence
> How to set isolation level permanently in sql server
No can do. Set it in your code.

> and how to check my currenct isolation level?
DBCC USEROPTIONS
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"florencelee" <anonymous@.discussions.microsoft.com> wrote in message
news:157f01c4a6de$7b0174a0$a401280a@.phx.gbl...
> Hi,
> How to set isolation level permanently in sql server
> and how to check my currenct isolation level?
> Thank you
> regards,
> florence
>

No comments:

Post a Comment