My app is running on SQL Server 2016 and PB 12.5. AutoCommit is set to False.
I want to run a stored procedure that does some updates so I need to do a commit after. I also want any updates that were pending before the stored procedure was called to remain pending until I commit or rollback.
My understanding is that I can do the following to isolate the updates in the stored procedure from the current transaction.