ansaurus

Question

SQL Server 2008: No 'release savepoint' for current transaction

Answer 1

A:

I don't know much about MySQL but it sounds a bit like using

Save Transaction <Name> and Rollback Transaction <Name>

to partially rollback a transaction to a named point. See MSDN

SPE109 2010-06-23 12:00:12

Those statements map to MySQL's SAVEPOINT <NAME> and ROLLBACK TO SAVEPOINT <NAME>; the purpose of RELEASE is to delete a savepoint without committing or rolling back at at all. From the MySQL Manual:"The RELEASE SAVEPOINT statement removes the named savepoint from the set of savepoints of the current transaction. No commit or rollback occurs. It is an error if the savepoint does not exist."I don't think those statements provide that functionality?

Craig 2010-06-23 12:11:52

I understand now, I've not come across anything to clear a transaction marker. I would guess you can probably ignore them

SPE109 2010-06-23 16:52:29

Answer 2

+1 A:

In SQL Server you do not need to do any operation to release a savepoint. Savepoints are 'released' automatically at the final transaction commit or rollback, you don't need to manage them intermediately.

Remus Rusanu 2010-06-23 19:21:42

Cool, that's what I'd hoped. Thanks!

Craig 2010-06-25 09:19:45

ansaurus

tags:

views:

answers:

SQL Server 2008: No 'release savepoint' for current transaction

related questions