title: How to change the default TRANSACTION ISOLATION LEVEL in SQL Server 2005?
body: <p>I know the default TRANSACTION ISOLATION LEVEL in SQL Server is "read committed".  If I want to change it to "READ UNCOMMITTED", how may i make this configuration change?</p>
  
  <p>note: I cannot use SET TRANSACTION ISOLATION LEVEL, which only apply in the current session.  I cannot add NOLOCK in the queries because there are thousands of queries involved.</p>
  
  <p>Thanks</p>
  
  <hr>
  
  <p>Thanks for your answer.  We are ok with reading dirty rows.  Update is not a problem in our case as well.  but, I really want to change this default config of isolation level.  Please kindly help.</p>
  
  <p>I cannot "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED".  I must make the global change.</p>
  
  <hr>
  
  <p>We have carefully reviewed both snapshot isolation level.  They cannot be used in our situation.</p>