MARS, Transactions and SQL Error 3997, 3988 or 3983

Mars and Transactions   MARS (multiple active result-sets) does allow multiple commands to be active on the same connection, however there are some limitations on allowing multiple transactions to be active. I received a number of questions around this lately. I’ll try to address the common denominator scenario in these questions and how to work…