Options

sqltransaction has completed it is no longer usable

sburrowssburrows Posts: 5 Bronze 1
edited October 28, 2014 9:07AM in SQL Packager Previous Versions
We have a change script generated by the packager and execute within our application. Sometimes when executed we get "sqltransaction has completed it is no longer usable", the whole script is rolled back (thankfully)
Try it again and it may work. Sooner or later it will (4 times is the worst situation so far)

All searches for this error indicate a programming error that should occur every time, closing the connection before the transaction is complete (no close connections in the script)
Any clues ?
Sign In or Register to comment.