1)I send out thousands of emails a day, should I use a third party component that queues email messages or can I use MSMQ?<BR>+++++++++++++++++++++++++++++++++++++++++ ++<BR>2)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,