SQL Error catching

   1:  begin catch

   2:  DECLARE

   3:  @ErrorMessage NVARCHAR(4000),

   4:  @ErrorNumber INT,

   5:  @ErrorSeverity INT,

   6:  @ErrorState INT,

   7:  @ErrorLine INT,

   8:  @ErrorProcedure NVARCHAR(200);

   9:  -- Assign variables to error-handling functions that capture information for RAISERROR.

  10:  SELECT

  11:  @ErrorNumber = ERROR_NUMBER(),

  12:  @ErrorSeverity = ERROR_SEVERITY(),

  13:  @ErrorState = ERROR_STATE(),

  14:  @ErrorLine = ERROR_LINE(),

  15:  @ErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-');

  16:  -- Build the message string that will contain original error information.

  17:  SELECT @ErrorMessage = 'Error %d, Level %d, State %d, Procedure %s, Line %d, ' + 'Message: '+ ERROR_MESSAGE();

  18:  -- Raise an error: msg_str parameter of RAISERROR will contain the original error information.

  19:  RAISERROR

  20:  (

  21:  @ErrorMessage,

  22:  @ErrorSeverity,

  23:  1,

  24:  @ErrorNumber, -- parameter: original error number.

  25:  @ErrorSeverity, -- parameter: original error severity.

  26:  @ErrorState, -- parameter: original error state.

  27:  @ErrorProcedure, -- parameter: original error procedure name.

  28:  @ErrorLine -- parameter: original error line number.

  29:  );

  30:  end catch