April 29, 2008 at 8:21 am
Is it possible to create a setup that anytime certain users/roles connect to a db that they always have transaction level set to READ UNCOMMITTED? We have business users that always forget with (nolock) hint.
April 29, 2008 at 9:39 am
Did you try the following syntax?
SET TRANSACTION ISOLATION LEVEL
{ READ COMMITTED
| READ UNCOMMITTED
| REPEATABLE READ
| SERIALIZABLE
}
April 29, 2008 at 9:43 am
I understand how the command works, I'm asking is there a way to have it automatically set that way for certain users whenever they login.
April 29, 2008 at 9:47 am
How are the users querying the database? If they are using SSMS, you can change the settings for queries under Query -> Query Options to default to Read Uncommitted.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply