On Mar 24, 2:40 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote: > what if you create the same table on a totally new database and run it > there ?
Good idea. I'll try that momentarily. In the meantime, I tried out wireshark and see that there is a reliable difference in what is getting sent. With 0.5.2 what gets sent is this: Query: set implicit_transactions on RPC Name: sp_datatype_info Query: SET IMPLICIT_TRANSACTIONS OFF Query: BEGIN TRANSACTION Query: INSERT INTO sa_test (data, time) VALUES ('bingo', '2009-03-24 14:57:58') Query: IF @@TRANCOUNT > 0 COMMIT TRAN Query: SET IMPLICIT_TRANSACTIONS OFF Query: BEGIN TRANSACTION Query: SELECT COUNT(*) FROM sa_test WHERE data='bingo' Query: IF @@TRANCOUNT > 0 ROLLBACK TRAN With 0.4.8 what gets sent is this: Query: set implicit_transactions on RPC Name: sp_datatype_info Query: INSERT INTO sa_test (data, time) VALUES ('bingo', '2009-03-24 14:57:58') Query: IF @@TRANCOUNT > 0 COMMIT TRAN Query: BEGIN TRANSACTION Query: SELECT COUNT(*) FROM sa_test WHERE data='bingo' Query: IF @@TRANCOUNT > 0 ROLLBACK TRAN Note that with 0.4.8 the TDS data sent relies on IMPLICIT_TRANSACTIONS being set ON, while with 0.5.2, this gets turned OFF, and then BEGIN TRANSACTIONs are sent. David --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---