My question is regarding transaction in SQL server. I began a transaction and start executing some scripts. I have given an error check so that if any error occurs I can call "rollback" or else can "commit". My question comes here. If a transaction begins and the power goes off in between, rollback is performed automatically with out executing the rollback statement. Can any body please explain how this is happening?<BR><BR>Thanks,<BR>Shinto