SQL Server 2008 R2 database isolation change

3740 pts.
Tags:
Database
SQL Server
SQL Server 2008 R2
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?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

SET TRANSACTION ISOLATION LEVEL

    { READ UNCOMMITTED

    | READ COMMITTED

    | REPEATABLE READ

    | SNAPSHOT

    | SERIALIZABLE

    }

[ ; ]

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • clark445kent
    Hi,

    You cannot change the isolation level as a database default. If you could, you sure would not want to default to read uncommitted. You' be guaranteed dirty reads and chaotic results.

    Thanks & Regards
    Clark Kent
    8,235 pointsBadges:
    report
  • ToddN2000
    I agree with Clark, it would not be a good practice. To unpredictable results.
    135,465 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: