setting ISOLATION LEVEL READ UNCOMMITTED in database level

• prakash.gr

  SSC-Addicted

  Points: 428

  More actions

  November 25, 2008 at 10:35 pm

  #128851

  Hi,

  first i am new to sql server:

  server version is sql server 2000

  we used to get lot of blocking session and we thought of use isolation level read uncommited instead of read commited(default behaviour)

  could any body advise me to set this parameter in database level

  thanks

  prakash

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  November 25, 2008 at 11:35 pm

  #903566

  Please do not cross-post.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• prakash.gr

  SSC-Addicted

  Points: 428

  More actions

  November 25, 2008 at 11:42 pm

  #903569

  sure mistake won't repeat next time.

  thanks

  prakash