468,514 Members | 1,528 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,514 developers. It's quick & easy.

how to change server option for isolaiton level?

neo
I'm having problem with locking in update and select.
my update takes long and select from clients happens all the time.
I know with NOLOCK in select or set transaction isolation level, I can
read data uncommited.
I want to know if there is an option I can change on server or
database
to change isolation level for all incoming connections.

thanks for your help in advance.
Jul 20 '05 #1
6 4692
AFAIK, you can't set READ UNCOMMITTED at the server level. This is
probably a good thing since one should read uncommitted data only in
specific situations where all off the ramifications have been fully
evaluated and understood.

--
Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index....partmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"neo" <se*******@hotmail.com> wrote in message
news:15**************************@posting.google.c om...
I'm having problem with locking in update and select.
my update takes long and select from clients happens all the time.
I know with NOLOCK in select or set transaction isolation level, I can
read data uncommited.
I want to know if there is an option I can change on server or
database
to change isolation level for all incoming connections.

thanks for your help in advance.

Jul 20 '05 #2
Hi

To add to Dan's comment...

Are you wanting to make the database read only?

John

"neo" <se*******@hotmail.com> wrote in message
news:15**************************@posting.google.c om...
I'm having problem with locking in update and select.
my update takes long and select from clients happens all the time.
I know with NOLOCK in select or set transaction isolation level, I can
read data uncommited.
I want to know if there is an option I can change on server or
database
to change isolation level for all incoming connections.

thanks for your help in advance.

Jul 20 '05 #3
neo
Thanks to Dan/John.

No I just wanted to allow dirty-read, not read-only db.

I thought there was an option in SQL to set db to allow read uncommited.
Maybe for SQL 7?
"John Bell" <jb************@hotmail.com> wrote in message news:<bo**********@titan.btinternet.com>...
Hi

To add to Dan's comment...

Are you wanting to make the database read only?

John

"neo" <se*******@hotmail.com> wrote in message
news:15**************************@posting.google.c om...
I'm having problem with locking in update and select.
my update takes long and select from clients happens all the time.
I know with NOLOCK in select or set transaction isolation level, I can
read data uncommited.
I want to know if there is an option I can change on server or
database
to change isolation level for all incoming connections.

thanks for your help in advance.

Jul 20 '05 #4
Hi

This is not something you would want do as a default, and when you do
require it, then it has to be a concious decission to allow this;
therefore not having it at server level or as a default for the
connection is probably a good thing. You can always set it for the
connection/session.

John

se*******@hotmail.com (neo) wrote in message news:<15*************************@posting.google.c om>...
Thanks to Dan/John.

No I just wanted to allow dirty-read, not read-only db.

I thought there was an option in SQL to set db to allow read uncommited.
Maybe for SQL 7?
"John Bell" <jb************@hotmail.com> wrote in message news:<bo**********@titan.btinternet.com>...
Hi

To add to Dan's comment...

Are you wanting to make the database read only?

John

"neo" <se*******@hotmail.com> wrote in message
news:15**************************@posting.google.c om...
I'm having problem with locking in update and select.
my update takes long and select from clients happens all the time.
I know with NOLOCK in select or set transaction isolation level, I can
read data uncommited.
I want to know if there is an option I can change on server or
database
to change isolation level for all incoming connections.

thanks for your help in advance.

Jul 20 '05 #5
neo
Thanks,
one more thing,
what about Query analyzer?
is there any way not to run "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"
everytime in Query Analyzer?
Jul 20 '05 #6
Hi

As far as I know, you can't do this, configurable options appear on
the tools/options dialogues and that is not one of them. If it was you
could use a specific configuration file. The only thing I can suggest
it to put it in a template.

John

se*******@hotmail.com (neo) wrote in message news:<15**************************@posting.google. com>...
Thanks,
one more thing,
what about Query analyzer?
is there any way not to run "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"
everytime in Query Analyzer?

Jul 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Richard | last post: by
1 post views Thread by Corrine | last post: by
7 posts views Thread by F. Michael Miller | last post: by
2 posts views Thread by Manish Tomar | last post: by
4 posts views Thread by Peter | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.