Well I wish it would be that easy, we have a pretty big application and since we have multiple databases depending on what the user run we might have up to 4 to 5 connections open.

The connections are made trhough SQLSTRINGCONNECT. My problem is that when the error handler of the application fires I want to rollback all the transactions as well as change the transactions to automatic if they are set to Manual.

Fabian