Hi,

Database: SQL Server 2000
Development Tool: VB 6.0

In a save button, i have several insert and update statement that has to be executed. In case of failure of any of the statement, i want to revert back to the state prior i had started the insert and update statement.

Could you please tell me how can i do so with VB as development tool and SQL Server as database?