CODEWITHSUNDEEP
sql-server
ZedZip
ZedZip

Reputation: 6456

How to detect where SET IMPLICIT_TRANSACTIONS ON?

I have a c++ application and run it on SQL Server 2019

server1\db1 - it works fine server1\db2 - it works strange

The app works different. I have detected in Profiler that db2 has

set implicit_transactions on

but the db1 has no this set.

I cannot find where this settings is: the app has no this statement.

Where it can be? may be implicitly?

Upvotes: 1

Views: 294

Answers (1)

HABO
HABO

Reputation: 15841

You can check the setting with:

select case when @@Options & 2 = 0 then 'Off' else 'On' end as Implicit_Transactions_State;

Ref: @@Options and user options.

Upvotes: 2

Related Questions