Post reply

is there any way to change sql server default isolation level ?

  • January 2, 2015 at 2:12 am

    #296402

    is there any way to change sql server default isolation level ?

    not for db level...entire sql server?

    Please advice

  • January 2, 2015 at 3:31 am

    #1767357

    dastagiri16 (1/2/2015)

    is there any way to change sql server default isolation level ?

    not for db level...entire sql server?

    Please advice

    No, there isn't. It's a connection setting, not a database or server setting.

    What is it that you want to accomplish?

  • January 2, 2015 at 5:34 am

    #1767375

    I just want to know..

    Thanks for your reply

  • January 14, 2015 at 10:58 pm

    #1770325

    Dastagiri16,

    This is a database level setting and can be controlled at the level of an individual query as well. I do not believe there are any instance wide settings for isolation level. If you want all your databases to have a certain isolation level then you could set your Model database to the desired isolation level and then every database should get its isolation level from the Model.

    http://technet.microsoft.com/en-us/library/bb522682(v=sql.105).aspx

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

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