I managed to use begintrans and committrans but for some reason my errorhandler label (containing the rollbacktrans) cannot be accessed. It gives a syntax error on the "on error goto errhandler" statement. Can anyone give me sample code on how to do rollbacks?

Thanks. (This is URGENT!!)