title: power off during long sql transaction
body: <p>Does anyone know what will happen if microsoft sql server's power is switched off during a long sql transaction?   will the db rollback the unfinished transaction by itself?</p>
  
  <p>Thanks</p>