rollback when sql script fails

stradinov · Post by **stradinov** » Tue May 20, 2008 5:09 pm

Hi, I'm evaluating InstallAware.

Is't possible to make the installer rollbacks when a sql script fails?

LarsS · Post by **LarsS** » Tue May 20, 2008 6:06 pm

If you are using MS SQL Server you can just use the Begin, Commit and Rollback transaction commands in your script together with some T-SQL error handling code.
See BOL for more info.

I would assume other SQL servers have similar functionality.

jimo · Post by **jimo** » Wed May 21, 2008 1:53 pm

Or check out SET XACT_ABORT in BOL.