Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
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 ...
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.