SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED same as (nolock)

• Roust_m

  SSCoach

  Points: 17410

  More actions

  April 28, 2011 at 10:31 pm

  #239381

  Hi,

  Just was wondering if putting this line at the beginning of a stored procedure equates to using (nolock) for all SELECT's in that stored procedure?

  Many thanks.

• ModestyBlaise84

  SSCommitted

  Points: 1931

  More actions

  April 28, 2011 at 11:22 pm

  #1317668

  Yes, it does.

  But be careful with reading uncommitted