0

I am trying to dirty check a SQL Server table, but I am not sure whether or not the settings are saved to the table and will effect other reads, or automatically reset after the read. I would like the uncommitted flag to only be used each time the procedure is called, and not effect other reads to the table.

Case 1: 

set transaction isolation level read uncommitted
select * from table

Case 2:

set transaction isolation level read uncommitted
select * from table
set transaction isolation level read committed

Is the last line in Case 2 necessary?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Matthew
  • 1,461
  • 3
  • 23
  • 49
  • When you are giving table hint, you do not need to turn it off, as these settings are at default database level – Ven Feb 12 '18 at 15:46
  • For more info refer to https://www.red-gate.com/simple-talk/sql/t-sql-programming/questions-about-t-sql-transaction-isolation-levels-you-were-too-shy-to-ask/ – Ven Feb 12 '18 at 15:50

0 Answers0