Post reply

How to set the default Isolation Level

  • April 4, 2008 at 2:24 pm

    #184807

    How do I set the default Isolation Level for one DB in sql 2005 ?

    I understand you can issue the SET ISOLATION LEVEL command from a client for that session, but I would like to default it to READ UNCOMMITTED for all clients connecting to sql 2005.

    I thought there was a global setting in the Sql 2005 Management Studio...

    Thanks,

    bob

  • April 4, 2008 at 8:01 pm

    #798743

    There is not a database level setting for this. You can only enable the new Row Versioning Isolation Levels at the DB level using:

    ALTER DATABASE DB_NAME

    SET READ_COMMITTED_SNAPSHOT ON;

    or

    ALTER DATABASE DB_NAME

    SET ALLOW_SNAPSHOT_ISOLATION ON;

    These just allow you to use the new optimistic concurrency settings. They do not change the database default isolation level from Read Committed

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • April 10, 2008 at 9:10 am

    #801039

    Thanks for confirming that.

    In my case, I need READ UNCOMMITTED when the client app refreshes the display of data. The refresh rate on our client is about 4 seconds, so it doesn't matter if it's behind 4 seconds. I'm more concerned with eliminating the hanging and the frequent deadlocks in my system.

    I could probably set the isolation level to read uncommitted at the beginning of certain sql procedures, then.

    Thanks,

    bob

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply