CODEWITHSUNDEEP
sql-servertransaction-isolationssms-17
Alexandr Kapshuk
Alexandr Kapshuk

Reputation: 1471

Change transaction isolation level for all queries

I am connecting to an SQL Server database with SSMS 2017 to check some errors in reports, and the DBA says that when I'm running heavy queries, it blocks the outgoing processes. So the solution is to set transaction isolation level to read uncommited or add with (nolock) in each query. My problem is that I'm running a lot of small queries, and sometimes I forget to add these sentences.

My question is, can I set transaction isolation level to read uncommited once and for all? Maybe there's an option in SSMS, or it can be set up for a specific user (me)?

Upvotes: 1

Views: 357

Answers (1)

user11380812
user11380812

Reputation:

There is an option in 'Query Execution' section, shown in the image below. If you set this option on your PC ( SSMS), it will reflect just you.

enter image description here

Upvotes: 2

Related Questions