----------------------------------------------------------- New Message on BDOTNET
-----------------------------------------------------------
From: jshanki
Message 7 in Discussion
you cannot have a commit inside a SP. dont use the commit inside SP, use
it in your ADO.NET transaction object. In this case even if your 4th SP
fails, then you can rollback.
With Warm Regards
Shankara Narayanan
****************************************
Impossible only means that you haven't found the solution yet.
****************************************
"spprivate"
<[EMAIL PROTECTED]> To: "BDOTNET" <[EMAIL PROTECTED]>
cc:
02/05/2004 06:18 PM Subject: Re: ADO.NET
Transaction--doubt
Please respond to
"BDOTNET"
(Embedded image moved to file: pic18958.gif)
(Embedded New Message on BDOTNET
image moved
to file:
pic17578.gif
)
(Embedded image moved to file: pic08365.gif)
ADO.NET Transaction--doubt
|-----------------------------+-------------------------------------------------------------|
| Reply |
|
| (Embedded image moved to |
|
| file: pic13007.gif) |
|
| | Reply to Sender (Embedded image moved to file:
|
| | pic11477.gif)Recommend
|
| | Message 6 in
Discussion|
| |
|
|-----------------------------+-------------------------------------------------------------|
|
|
|
|
|From: (Embedded image moved to file:
pic01200.gif)(Embedded |
|image moved to file: pic26058.gif)spprivate
|
|
|
|Ravi,
|
|How can we roll back a commited transaction..As I said
,what |
|ever statements inside stored proc..this get commited..
|
|Cheers
|
|Satheesh
|
|
|
-------------------------------------------------------------|
View other groups in this category.
(Embedded image moved to file: pic06439.gif)
Also on MSN:
Start Chatting | Listen to Music | House & Home | Try Online
Dating | Daily Horoscopes
(Embedded image moved to file: pic02303.gif)
To stop getting this e-mail, or change how often it arrives, go to
your E-mail Settings.
Need help? If you've forgotten your password, please go to Passport
Member Services.
For other questions or feedback, go to our Contact Us page.
If you do not want to receive future e-mail from this MSN group, or
if you received this message by mistake, please click the "Remove"
link below. On the pre-addressed e-mail message that opens, simply
click "Send". Your e-mail address will be deleted from this group's
mailing list.
Remove my e-mail address from BDOTNET.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
