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

avatar image

Sharma
1.3k 88 91 94

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 Sharma

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

avatar 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.

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:

x2072
x109
x14

asked: Aug 22, 2012 at 03:28 AM

Seen: 1322 times

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

Copyright 2016 Redgate Software. Privacy Policy