I have a trigger on a table that calls an external dll to pass a message (string) to MQSeries. A question has arisen regarding transactional consistency. My trigger code has logic to trap and handle any errors returned by the dll.
I'm worried that records are being rolled back out of the table if any of the dll calls fail. Does the code provided appear to handle any errors and prevent the record from being rolled back? If I haven't provided enough information let me know.
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!