Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql Command Timeout
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 1.1
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01043997
Message ID:
01245588
Views:
30
The tips in the help file for globally changing the Command Timeout were very useful and easy to do because there is a CommandTimeout property on the dao class. Is there a way to globally change the isolation level of SQL Server too? The default isolation level for SQL Server is READ COMMITTED. I would like to globally change that level so that there is not so much SQL locking in my application.

Hint: SQL help says that there are two common ways to set the isolation level.
1. Run the SET TRANSACTION ISOLATION LEVEL Transact-SQL statement every time you open a connection.
2. ADO.NET applications using the System.Data.SqlClient managed namespace can specify an IsolationLevel option using the SqlConnection.BeginTransaction method.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform