Hi All,<BR><BR>I am facing a problem in rollback in sql-server. Suppose I have one ASP page where I have few Insert statements. I need to set rollback mechanisam where if any of the insert statement fails then all insert statements which are executed before that should be rolled back.<BR><BR>Does anyone know the syntext for this?<BR><BR>Thanx in advance,<BR>Ani.