Default isolation level for tables option?

Table property or option that can be applied to a table in SQLServer which enforces default isolation level for that table?

asked Aug 22 '12 at 03:28 AM in Default

Amardeep
1.3k ● 71 ● 82 ● 86

Isolation levels are not set at the object level.

What are you trying to accomplish?

Aug 22 '12 at 04:02 AM SirSQL

Looking to set Isolation levels on table level.

Aug 22 '12 at 05:02 AM Amardeep

I think that was clear. But what is it that you are trying to solve by putting isolation level on a table?

Aug 22 '12 at 05:57 AM Magnus Ahlkvist

(comments are locked)

1 answer:

hi, as i know we can't set Isolation level at the table level. but we can control the isolation in 2 levels. 1. by setting the isolation level at the server level (it us in the options tab) 2.or by setting the isolation level at the transaction level.

answered Sep 02 '12 at 10:19 AM