Transaction isolation level read uncommitted ?

• well0549

  SSCrazy

  Points: 2259

  More actions

  March 3, 2003 at 4:41 am

  #80842

  How long does Transaction isolation level read uncommitted last ?

  If it is the first line in a stored procedure,

  will it only affect the current stored procedure or will it affect the complete session.......

  So is the Transaction ISOLATION LEVEL still active when the SProc finishes.

  I have looke din the books online but could not find it.

  If anybody knows the answer it would be nice....

• well0549

  SSCrazy

  Points: 2259

  More actions

  March 3, 2003 at 5:15 am

  #450113

  DBCC USeroptions gave the answer

  sorry for the question....