SQL Server TRANSACTION across mutliple SP calls
Posted on 2004-09-17
I am working on a VB6 project that uses SQL Server 7 database. I was hoping to retro-fit a transaction to cover all the processing for a each particular customer. I was trying to issue a BEGIN TRANSACTION MyCustTran then do various processing and call 10 different stored procedures from VB. It seems this can't be done? Get error "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0."
I was wondering if sp_getbindtoken could be used for this. I'm trying to avoid major recoding of the application. Hope you can help