Bryan Pendleton wrote:
The key question is whether the statement with error should (or could) rollback the active transaction?Does this same situation arise with an embedded configuration? If so, how does the embedded engine handle your test case?
Some exceptions are transaction level, such as deadlock or lock timeout, thus an error from a statement can rollback the transaction.
Dan.
