473,324 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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
Aug 29 '05 #1
2 5306
Driesen via SQLMonster.com (fo***@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, es****@sommarskog.se

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

Aug 29 '05 #2
Thanks very much Erland .
That helped me.

Driesen
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...neral/200508/1
Aug 30 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

133
by: jonathan | last post by:
hey all, I realize that this question might pop up from time to time, but I haven't seen it a while and things might of changed, so - Right now (July 2004) how does mysql stand up in...
22
by: Robert Brown | last post by:
suppose I have the following table: CREATE TABLE (int level, color varchar, length int, width int, height int) It has the following rows 1, "RED", 8, 10, 12 2, NULL, NULL, NULL, 20...
3
by: heynothanks | last post by:
(MSSQL2000) I have read the transaction/locking sections in the MS-help, online and several books. What I want to understand is the transaction behavior in single statements . If I have a...
16
by: Nid | last post by:
How do I do row-level locking on SQL Server? Thanks, Nid
1
by: Job Lot | last post by:
I am trying to run a system stored procedure (SP_DETACH_DB) from vb.net application. I am getting the following error SP_DETACH_DB not allowed within multi-statement transaction. How can I fix...
2
by: Adnan | last post by:
Hi Guys, I have one stored procedure on SQL 6.5 and retrieving data from SQL 2000. I have defined a linked server on SQL 6.5. But I am getting following error:- "Heterogeneous queries require...
29
by: pb648174 | last post by:
I have a very long transaction that runs on the same database that other users need to use for existing data. I don't care if they see data from the transaction before it is done and am only using...
2
by: Uncle Sam | last post by:
Hello, Is there anyway.. we can disable AUTOCOMMIT option in MSSQL server while executing the SQL queries via SQL ANALYZER
0
by: Narasareddykr | last post by:
Hi all, i am new in SQL Server 2005. how to AUTOCOMMIT ON. i am Try to Query/Query Option/Execute/ANSI IMPLICIT_TRANSACTIONS ON, and Tools/Options/Execute Query/ANSI IMPLICIT_TRANSACTIONS ON. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.