ErrorRaise from within SP - does it doom the transaction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin C - 06 May 2004 14:06 GMT

If I call ERRORRAISE or SQL Server raises an exception from my stored proc
will it doom the transaction? I am getting that type of behavior. I was
anticipating being able to trap for a specific *exceptional* condition and
reacting, but when the exception is raised from my sp or sql server it
appears to rollback everything I attempted.

Kevin

Reply to this Message

Florin Lazar [MSFT] - 29 May 2004 09:19 GMT

Hi Kevin,

I recommed you to ask this question into a SQL Server newsgroup.

Regards,

Signature

Florin Lazar - Microsoft - [ http://blogs.msdn.com/florinlazar ]
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
This posting is provided "AS IS" with no warranties, and confers no rights.

> If I call ERRORRAISE or SQL Server raises an exception from my stored proc
> will it doom the transaction? I am getting that type of behavior. I was
[quoted text clipped - 3 lines]
>
> Kevin

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...