Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1098
  • Last Modified:

NOLOCK by Default

Is there a setting in Server Management Studio (or with SQL) that will run all of my SELECT queries with NOLOCK by default? I know I can specify in the actual query, but I do not want to. I just want it set for the entire session.
0
leonstryker
Asked:
leonstryker
1 Solution
 
ajanthonyCommented:
In SQL 2008 Server Management Studio

Click Tools -> Options.
In the treeview, Underneath Query Execution -> SQL Server -> Advanced.

Set transaction isolation level to READ UNCOMMITTED
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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