Is there a trick to using Transactions in SQL Server? If I do a Begin Transaction and then attempt to do a Commit I always get the following error:
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
At first I thought was because I was using PreparedStatements but this happens with straight SQL too.
For my purposes MBS is NOT a solution so please don't bring it up.
Need a solution or I'm giving some money back to a client.