I tried with the below code and got the result. Even the table updated by trigger will be rolled back.

BEGIN TRAN

DECLARE @INTERRORCODE INT

INSERT INTO BOOKS(BOOKID,BOOKDESCRIPTION,ISBN) VALUES(2,'22','222')

INSERT INTO BOOKS(BOOKID,ISBN) VALUES(2,'222')

SELECT @INTERRORCODE...

Hi,

Thanks for the reply.

But what about infinite looping error. I feel cursors cant have the infinite looping error.

Please advice.