June 11, 2013 at 11:37 pm
Hi all,
what is the default isolation level for sql server. Does it changed in newer versions. what is the use of it. If we have to change, how to change that level. i have done some googling .. but i am unable to understand the very purpose of it. why is that much important.
June 11, 2013 at 11:52 pm
ReadCommited is default isolation level in sql server
here is more information that you can get on isolation level
http://msdn.microsoft.com/en-us/library/ms173763.aspx
and here is the link that you might find answer to set default isolation level on server side.
June 12, 2013 at 7:31 am
You cannot change the default isolation level, i.e. all new sessions will begin in READ COMMITTED isolation level. You can however enable the READ COMMITTED SNAPSHOT ISOLATION per database which is a mode of READ COMMITTED or explicitly change the isolation level within a session by using SET TRANSACTION ISOLATION LEVEL or by using table hints.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply