DECLARE @ErrorSeverity INT
DECLARE @ErrorState INT
DECLARE @ErrorMsg VARCHAR(MAX)
SELECT
@ErrorSeverity = ERROR_SEVERITY(),
@ErrorState = ERROR_STATE(),
@ErrorMsg ='ErrorNumber: ' + ISNULL(CAST(ERROR_NUMBER() AS VARCHAR), 'NULL') +
', ErrorSeverity: ' + ISNULL(CAST(ERROR_SEVERITY() AS VARCHAR), 'NULL') +
', ErrorState: ' + ISNULL(CAST(ERROR_STATE() AS VARCHAR), 'NULL') +
', ErrorProcedure: ' + ISNULL(ERROR_PROCEDURE(), 'NULL') +
', ErrorLine: ' + ISNULL(CAST(ERROR_LINE() AS VARCHAR), 'NULL') +
', ErrorMessage: ' + ISNULL(ERROR_MESSAGE(), 'NULL')
RAISERROR(@ErrorMsg, @ErrorSeverity, @ErrorState)