Hi Friends,

I want to change my database isolation to read uncommitted in SQL server 2008 R2, Can someone tell me the exact process and how should I can achieve this?

Thanks

Subhash

There is no setting for this at the database level. There is a session setting (SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED) and you can set it at the query level.

I strongly encourage you, however to read up on the potential consequences of doing dirty reads before you venture further this road. 

Exacpt Query level, is there any other way to put the READ UNCOMMITTED in single shoot for all coming connection query's?  Like READ COMMITTED.

No, those are your options. Query level and session level. You cannot change the default.

I would not suggest you to use it even. This is highly not recommended you would end up messing your system more. may I know what is your requirement ?

Actually with lots of select statement currently we are facing shared locking (LCK_M_S) wait time on most of the query's so need to come out from this, And converting all select statement in (nolock) will take longer time, So making a test setup with change the database isolation level to READ UNCOMMITTED and wanted testing.