Post reply

setting transaction isolation level for a database

  • January 30, 2008 at 6:49 am

    #119735

    hello

    is there a way of setting the transaction isolation level at the database level so all connections use it?

    thanks!!!!!

  • January 30, 2008 at 7:13 am

    #773269

    I know you can set options regarding Snapshot isolation (allowing) and whether you want READ COMMITTED to be implemented via snapshot but I don't think there is more...

  • January 30, 2008 at 7:50 am

    #773290

    The connection is the highest level you can set the iso level. I've been on MS for a long time to give us DB-level isolation. Anyway, the short answer is no.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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