patternsqlMinor
Disable autocommit for SQL Server connection in Oracle SQL Developer
Viewed 0 times
serversqldisablefordeveloperautocommitoracleconnection
Problem
I am using Oracle's SQL Developer to execute queries against my SQL Server 2008 database as I simply can't work with SSMS as long as it doesn't support Ctrl + Return to execute statements...
Anyway, statements in SQL Server seem to be autocommit even when using Oracle SQL Developer. Is it possible to change this on a permanent basis?
Anyway, statements in SQL Server seem to be autocommit even when using Oracle SQL Developer. Is it possible to change this on a permanent basis?
BEGIN TRANSACTION is not a solution for me.Solution
SQL Server uses autocommit mode by default. This cannot be changed permanently.
There are two ways implicit transactions (non-autocommit) can be turned on:
-
At the server level such that new sessions use it by default, using
-
For a session, using
There are two ways implicit transactions (non-autocommit) can be turned on:
-
At the server level such that new sessions use it by default, using
sp_configure 'user options' -- this may or may not work depending on how SQL Developer was implemented.-
For a session, using
SET IMPLICIT_TRANSACTIONS ON.Context
StackExchange Database Administrators Q#21424, answer score: 2
Revisions (0)
No revisions yet.