We are calling stored procedures in a sister database using direct SQL to update certain values in that database based on actions performed in our application. The stored procedures have BEGIN TRAN and COMMIT TRAN commands in them. In such
cases what should the transaction settings be in xPa and does it even matter?
Over time we have got 2 syntaxes appearing in the direct SQL itself. First has just the Exec command and the second the syntax is
set implicit_transactions on
set implicit_transactions on
exec xxxxxxxx :1,:2,':3',':4',':5'
IF @@TRANCOUNT > 0 COMMIT TRAN
IF @@TRANCOUNT > 0 COMMIT TRAN
set implicit_transactions off
set implicit_transactions off
xPa 2.5d and MSSQL
Is either correct and do they affect how the xPa transaction is configured?
The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you are not the intended recipient you should not read, copy, retransmit or disclose its contents. If you have received this email in error please delete it
from your system immediately and notify us either by email or telephone. The views expressed in this communication may not necessarily be the views held by McLaren Racing Limited.
McLaren Racing Limited, McLaren Technology Centre, Chertsey Road, Woking, Surrey, GU21 4YH, UK. Company Number: 01517478
