Posted by Erland Sommarskog on 08/30/05 00:34

Driesen via SQLMonster.com (forum@SQLMonster.com) writes:
> The SET IMPLICIT_TRANSACTIONS 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/techinfo/productdoc/2000/books.asp

• Next in forum: Re: No results found for my search!
• Prev in forum: Re: Rewrite a WHERE clause
• Thread view: Re: SET IMPLICIT_TRANSACTIONS ON

[Reply to this message]