In scripting sometimes I use <BR><BR>cn.execute,numa<BR>cn.begintrans<BR>if numa =1 then &#039insert or update was made.<BR> cn.commit<BR>else<BR> cn.rollback<BR>end if<BR>***<BR>Someone told me that I should use stored procs, for speed , eff.<BR>....<BR>1)Does stored procs use the begin trans, commit and rollback? I take the numa=1 as a return value and display something. <BR>2)I need to know if a stored proc updated or inserted, but I dont know how to do this.<BR> thank you on friday,