what is the default Isolation level for sql server?

[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

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

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

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

@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

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