How to enable automatic transaction detection in SQL Server Management Studio?

Question

I’m used to working with tools like Toad or PL / Sql Developer for Oracle and every SQL statement that I run in the query window starts automatically under the trasaction area. So, if my SQL statement is incorrect, or even if I missed something on the SQL script, I can roll back by clicking on the button in the user interface. If everything works as expected, I can click on another button to complete the current transaction. In the tools I mentioned, I don’t need to write SQL statements to start, commit, or roll back a transaction. Each SQL statement has an implicit transaction associated with.

Is there a way to achieve the same functionality in SQL Server Management Studio 2008?

Answer 1

You will need to install "Implict Transactions" in tools..options..query

To enable COMMIT or ROLLBACK, I can only think of using CTRL + shortcuts