SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:52 AM
| ||||
| ||||
 SET IMPLICIT_TRANSACTIONS ON Hi all 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? Thanks in advance Driesen -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums...neral/200508/1      |
|
02-29-2008, 08:52 AM
| |||
| |||
| Re: SET IMPLICIT_TRANSACTIONS ON 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/techinf...2000/books.asp |
|
02-29-2008, 08:53 AM
| ||||
| ||||
| Re: SET IMPLICIT_TRANSACTIONS ON Thanks very much Erland . That helped me. Driesen -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums...neral/200508/1 |
Linear Mode
