George George

George George

  • NA
  • 778
  • 0

RAISEERROR problem

Jan 20 2009 2:15 AM

Hello everyone,

If in a store procedure, it is using SET XACT_ABORT ON (auto rollback transaction when there is error). Currently, I just rely on the output of the store procedure (when there is any errors inside) to handle success/error at client side (e.g. ADO.Net client), now I want to add RAISEERROr statement to throw the error outside to client. But I can not think of how to add RAISEERROR and fill in the related parameters for this function. Does anyone have any ideas?

Here is my pseudo code.

[Code]
SET XACT_ABORT ON;

-- DML operations

commit;
[/Code]

thanks in advance,
George