Default Isolation Level

Is there a way to change the server default isolation level from READ
COMMITTED to something else. I mean the server default not resetting a
connection's default with SET TRANSACTION ISOLATION LEVEL <>-- Kevin Jackson wrote: --
>>Is there a way to change the server default isolation level from READ
>COMMITTED to something else. I mean the server default not resetting a
>connection's default with SET TRANSACTION ISOLATION LEVEL
--
Hi Kevin,
The answer to your question is NO.
May I ask why you wish to change this default isolation level? What specific issues are you facing?
Hope this helps,
-Eric Cárdenas
SQL Server support|||Hi Kevin,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
Eric is right that you cannot change the server default isolation level.
Here I'd like to add some more information.
The server setting is in effect unless overridden at a lower level.
1) Server level is always "Read Committed" - there is no way to change it.
2) Database level is always at the server level - there is no way to change
it.
3) For a given connection, use "DBCC USEROPTIONS" to see options that are
"SET", anything not listed is at the default server level.
4) For a given query, locking hints can use used to change the isolation
level.
I hope this information would answer your question and if you need more
help, please feel free to post any new message here and I am ready to
provide help.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.sql