Set READ UNCOMMITTED (dirty read) at login.

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?

THC  (richardrios@clearch
annel.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, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp