title: SET TRANSACTION ISOLATION LEVEL Scope on stored procedure
body: <p>I am creating a stored procedure and I do not want any locking through out the script. I am sure that I need to state "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" in the beginning of the script. But I am not sure how to start after the statement. One of the example from Microsoft show that start with "BEGIN TRANSACTION" and end with "END TRANSACTION". There is someone who starts without any  BEGIN and END statement after "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED". Please, suggest me for the right way of using "SET TRANSACTION ISOLATION LEVEL" statement to achieve my goal.</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/aa259216(v=sql.80).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa259216(v=sql.80).aspx</a></p>
  
  <pre><code>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
  GO
  BEGIN TRANSACTION
  SELECT * FROM publishers
  SELECT * FROM authors
  ...
  COMMIT TRANSACTION
  </code></pre>
  
  <p><a href="https://stackoverflow.com/questions/7975936/sql-server-how-to-set-default-isolation-level-for-the-entire-stored-procedure">SQL Server: how to set default isolation level for the entire stored procedure?</a></p>
  
  <pre><code>BEGIN
  SET TRANSACTION ISOLATION LEVEL READ COMMITTED
   -- will a transaction level for a atomic transaction created by SQL Server for this statement be READ COMMITTED 
  SELECT * FROM T
  END
  </code></pre>