CODEWITHSUNDEEP
sql-servert-sqlssms
kalitsov
kalitsov

Reputation: 1639

Turn off auto committing in SQL Server Management Studio (SSMS)

I’m looking for an option to explicitly commit/rollback every query executed in SSMS without the need to start the transaction explicitly. By default SSMS auto commits leaving no option to rollback.

Upvotes: 3

Views: 18823

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 88881

You can SET IMPLICIT_TRANSACTIONS ON in a query window.

If you set this in the Query/Query Options menu it will be set just for the current query. If you set this in the Tools/Options/Query Execution/SQL Server/ANSI menu it will be the default for all new queries.

enter image description here

Upvotes: 11

Related Questions