x

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?
more ▼

asked Aug 22, 2012 at 03:28 AM in Default

Amardeep gravatar image

Amardeep
1.3k 87 88 89

Isolation levels are not set at the object level.

What are you trying to accomplish?
Aug 22, 2012 at 04:02 AM SirSQL
Looking to set Isolation levels on table level.
Aug 22, 2012 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, 2012 at 05:57 AM Magnus Ahlkvist
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Sep 02, 2012 at 10:19 AM

kumardba gravatar image

kumardba
10 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1840
x84
x13

asked: Aug 22, 2012 at 03:28 AM

Seen: 1121 times

Last Updated: Sep 02, 2012 at 10:19 AM