469,921 Members | 2,215 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Set READ UNCOMMITTED (dirty read) at login.

THC
Is it possible to set READ UNCOMMITTED to a user connecting to an SQL
2000 server instance? I understand this can be done via a front end
application. But what I am looking to do is to assign this to a
specific user when they login to the server via any entry application.
Can this be set with a trigger?

Jul 23 '05 #1
1 2352
THC (ri*********@clearchannel.com) writes:
Is it possible to set READ UNCOMMITTED to a user connecting to an SQL
2000 server instance? I understand this can be done via a front end
application. But what I am looking to do is to assign this to a
specific user when they login to the server via any entry application.
Can this be set with a trigger?


No. Each process can issue "SET TRANSACTION ISOLATIION LEVEL READ
UNCOMMITTED" when it logs in, but there is no way you as admin can
set this default.

Then again, making dirty reads the default isolation level is a pretty
wild thing to do, so I would suspect that you real problem has a
completely different solution.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by francis70 | last post: by
11 posts views Thread by Markus Breuer | last post: by
8 posts views Thread by Pham Nguyen | last post: by
1 post views Thread by Karl | last post: by
2 posts views Thread by Bernd Hohmann | last post: by
7 posts views Thread by Igor | last post: by
3 posts views Thread by Rahul Babbar | last post: by
reply views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.