Thx @SruthiA but I don't need SP just a script to create table, insert in the table one time. The point is I need to rollback the inserts if them fail and don't want AUTOCOMMIT in the way. So how can… (View Post)