what is the default Isolation level for sql server?

Posted by Udaysimha under Sql Server on 2/4/2012 | Points: 10 | Views : 11968 | Status : [Member] | Replies : 6
Hi All,
Please let me know the default isolation level for sql server.

Thanks

uday


Responses

Posted by: Omniitstudent on: 2/4/2012 [Member] Starter | Points: 25

Up
0
Down
[B]By default, SQL Server will use Read Commmited if that is your default isolation level BUT if you do not additionally specify a locking strategy in your query, you are basically saying to sql server "do what you think is best, but my preference is Read Commited".



omprakash

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 2/5/2012 [Member] Silver | Points: 25

Up
0
Down
http://social.msdn.microsoft.com/Forums/en/transactsql/thread/0fcb366c-de08-4816-af09-f6083822b7e8

Hi, this link may help you.

Thanks,
Sanjay

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 2/5/2012 [Member] Silver | Points: 25

Up
0
Down
http://www.sql-server-performance.com/2007/isolation-levels-2005/
Hi Uday,
This link also help you about default isolation level of sql server.
Thanks,
Sanjay

Thanks,
Sanjay

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Neeraaj.Sharma on: 7/5/2013 [Member] Starter | Points: 25

Up
0
Down
By default, SQL Server will use Read Commmited

you can check the isolation level of DB using

DBCC useroptions



visit my blog: www.tutorialsqlserver.com



Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pandians on: 7/5/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
@Neeraaj.Sharma

DBCC useroptions is not be DB level.

Its specific to a SESSION or CONNECTION level! Do you agree ?

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Neeraaj.Sharma on: 7/5/2013 [Member] Starter | Points: 25

Up
0
Down
Completely Agree with U @Pandians , you are the one of most valued SQL SERVER member here:

This query shows Session Isolation level, however if you have not overright the isolation level
for the current session, then only it will show the DB isolation level.
please add comment if you want to add some more details.



Visit my Blog www.tutorialsqlserver.com



Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response