Try Catch Block

Hi,

I would probably use XACT ABORT like below

BEGIN CATCH
  IF XACT_ABORT <>0
 

Hi Shanky, shouldn't that be

BEGIN CATCH
  IF XACT_STATE() <> 0