dotnet component services: ErrorRaise from within SP - does it doom the transaction -- dotnet component services

ErrorRaise from within SP - does it doom the transaction

Kevin C
5/6/2004 8:06:00 AM

dotnet component services:

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

Re: ErrorRaise from within SP - does it doom the transaction

Florin Lazar [MSFT]
5/29/2004 1:19:44 AM

Hi Kevin,

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

Regards,
--
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.

[quoted text, click to view]