CREATE Procedure sp_Preset AS INSERT INTO Header (..) VALUES (...) INSERT INTO Detail (..) VALUES (...) INSERT INTO Detail (..) VALUES (...) INSERT INTO Detail (..) VALUES (...)What if the 2nd insert into the Detail table fails for whatever reason, will all the above inserts be rolled back automatically or do I have to wrap this all into a transaction?