While debugging my other server problem, I noticed that that only the
first BEGIN and COMMIT are logged on the server with sql statement
logging enabled. It seems that the subsequent transaction control
statements are being executed correctly, it is just that they are not
being logged by the server. Is this to be expected? If so, it makes
debugging a bit difficult as you can't see what commits are really being
executed when you have sql statement logging enabled.
Thanks,
--Barry