Set Implicit Transactions ON
If implicity transactions is enabled then the transaction is automatically started whenever select,insert,grant,delete,update,revoke,fetch,alter table,drop statement is made i.e instead of begin trans made the transaction is started.Users must commit the transaction before closing the database connection else it has to be rolled back.