Sunday, January 17, 2010

Implicit Transaction action in SQL SERVER

Implicit transactions actions are always enabled on Oracle servers. If you would like to have the same functionality in SQL Server, enable the SET_IMPLICIT_TRANSACTIONS connection property for each connection created.

Let's see an example:



Note that if you disconnected from SQL Server without rollback or commit ,your changes will not affect it to table.

No comments: