SET IMPLICIT_TRANSACTIONS OFF breaks MSSQL when using FreeTDS

[Mike Bayer]

line 1061 of mssql.py. why did we add this ?

[Michael Trier]

That code was added to fix savepoint support. One of the problems with MSSQL with Implicit Transactions is that it only gets turned on once a DML statement gets executed. Unfortunately issuing a savepoint doesn't turn on the implicit transaction. Therefore we were in a situation where there was no begin transaction, but there was a savepoint issued.

Thread of discussion here http://groups.google.com/group/sqlalchemy/browse_thread/thread/21ae6f7ed2686319#

[Michael Trier]

As of 541a0c8491bf3a966741adf8cdb524e4aab72e1b we are no longer doing this. It would be great if we could get confirmation that this is in fact working on FreeTDS now.

[Mike Bayer]

closing this for now.

[Mike Bayer]

Removing milestone: 0.5.4 (automated comment)