• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1084
  • Last Modified:

Set the default isolation level for all connections

How can I set the default isolation level for all connections.
I'm using Microsoft SQL Server  2000
I know that i can set isolation level in my VB - ado connection.
           Connection.IsolationLevel = adXactReadUncommitted
I know that i can set isolation level each time i want to do a query.
          " SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED "

I have about 300 different crystal report that i use in my VB6 application.
Each report (and subreport) have to used a ISOLATION LEVEL READ UNCOMMITTED.

Is there a way  to set the default isolation level for all connections.


 
0
SimonQc
Asked:
SimonQc
1 Solution
 
Kevin3NFCommented:
Why on earth would you want to populate your Reports with potentially dirty data?

I don't think you can set it for all connections...you have to build it into the proc or connection
0
 
tlovieCommented:
I looked for a server wide setting to no avail.  I don't think you can change it from the default of READ COMMITTED on a server or database wide setting.  You can set it when you create the connection.

0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now