Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
but I do get no message returned and no record has been saved, while I did see @@TRANCOUNT is having the value of 2, right before the last "if" part. why?
... begin try insert into ... end try begin catch select @ErrorMessage=ERROR_MESSAGE(); if @@TRANCOUNT>0 begin rollback tran set @message='...' return end end catch if @@TRANCOUNT>0 begin commit tran set @message='...' end ...
Join the community of 500,000 technology professionals and ask your questions.