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
Technology Tips and News
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.