Microsoft SQL Server forum - SET IMPLICIT

Author

SET IMPLICIT_TRANSACTIONS ON

Driesen via SQLMonster.com

2005-08-29, 9:23 am

Hi all

The SET IMPLICIT_TRANSACTION
S ON syntax turns on Begin Transaction by default,
yet when the ROLLBACK command is used everything in that session gets rolled
back. Is there a way to use the set implicit command to rollback only the
last transaction?

Thanks in advance
Driesen

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200508/1

Erland Sommarskog

2005-08-29, 8:24 pm

Driesen via webservertalk.com (forum@webservertalk
.com) writes:
> The SET IMPLICIT_TRANSACTION
S ON syntax turns on Begin Transaction by
> default, yet when the ROLLBACK command is used everything in that
> session gets rolled back. Is there a way to use the set implicit command
> to rollback only the last transaction?

You can use SAVE TRANSACTION to set up save points. These you can roll back
to.

Note that in SQL Server nested transactions does not really exist. That is,
when you commit an inner transaction, all that happens is that a counter
is decremented.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Driesen via SQLMonster.com

2005-08-30, 7:24 am

Thanks very much Erland .
That helped me.

Driesen

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200508/1

Sponsored Links