DI puts a transaction around the DB calls, see https://bobj-board.org/t/102747
If this is SQL, either put into the SP as the first item (before it does anything to manipulate data)…
SET IMPLICIT_TRANSACTIONS OFF
…or in the script within the sql function.
HuwD (BOB member since 2007-04-19)