strSQL = INSERT_Statement ===&#062; (table1) <BR>connectionobject.execute strSQL <BR>strSQL1 = INSERT_Statement1 ===&#062; (table2) <BR>connectionobject.execute strSQL1 <BR><BR>Response.Redirect " abc.asp " <BR><BR>99% of the time BOTH the inserts are executed. <BR>VERY RARELY the "INSERT_Statement1" is NOT getting executed. <BR><BR>I would expect some error when the Insert statement fails, but unfortunately I dont see any error and the REDIRECT statement is getting executed. <BR><BR>How can I overcome this strange problem ?<BR>Can I begin trasaction (before) and End Transaction(after) these INSERT statements ??