Implicit Transactions on MSSQL

[Brian Smith <BSmith@TEMPO.CO.UK>]

We have recently migrated our mainstream SQR system from v3(!) on Sun to
v6.0 (and now 6.1.4) on Windows NT/ODBC. We can see in the trace that every
SQR report issues a SET IMPLICIT TRANSACTION ON command before executing the
report code proper, and this is causing major blocking contention on the SQL
Servers (mostly MSSQL 6.5, some SQL7 and SQL2k). Reports that used to take a
few minutes are now sometimes taking hours. We use temporary tables quite a
lot, and this exacerbates the problem. The SQR files themselves have not
been changed.

I think I've seen this mentioned before, but has anyone found a solution.
I've tried the 6.20 beta, but it's just the same.


Brian Smith







***IMPORTANT***
The information in this mail is confidential and is intended solely for the
addressee. Access, copying or re-use of information in it by anyone else is
unauthorised. Any views or opinions presented are solely those of the author
and do not necessarily represent those of Tempo Ltd or any of its
affiliates.
"NB Kahn and AV Lomas were appointed Joint Administrators of Tempo Holdings
Limited and certain subsidiaries on 24th September 2001 by order of the
court to manage the affairs and business of the Company without personal
liability. NB Kahn and A V Lomas are licensed to act as Insolvency
Practitioners by the Institute of Chartered Accountants in England and
Wales."