patternsqlMinor
Check another session's IMPLICIT_TRANSACTIONS setting
Viewed 0 times
implicit_transactionssettinganothersessioncheck
Problem
In SQL Server, you can find
How to find the
This can definitely be done, because SQL Server Profiler shows it.
IMPLICIT_TRANSACTIONS value for own session via @@OPTIONS.How to find the
IMPLICIT_TRANSACTIONS value for another session?This can definitely be done, because SQL Server Profiler shows it.
Solution
There's no built-in way to achieve this.
Vote for a product improvement at Easier identification of Implicit Transactions (archive link until Microsoft migrates User Voice content)
In the meantime, the workarounds are:
Vote for a product improvement at Easier identification of Implicit Transactions (archive link until Microsoft migrates User Voice content)
In the meantime, the workarounds are:
- Run a server-side trace (deprecated) including the ExistingConnection event class
- Use the
existing_connectionextended event.
Context
StackExchange Database Administrators Q#294993, answer score: 8
Revisions (0)
No revisions yet.