See you are getting 24 because of cartesian.

So if you use

select sum(distinct(s.quantity))--,s.email

from sale s

inner join eval e

on s.email = e.email

where s.email = 'email1'

if will give you correct result.

As you have mentioned that the recovery model is simple, so I believe yes. But I have never done that. But I have used sp_repldone and worked as expected....

Anything meaningful?

I though you are looking for something to "What if i Just want to mark just the transaction in question as done.. using the @xactid ", and the url...

Check this url.. it may help.

http://blogs.msdn.com/b/repltalk/archive/2011/08/23/using-sp-repldone-to-skip-a-transaction.aspx