> >I understand that using triggers
> > > offers me transaction safety, ie if one of the triggers in the process
> > > fails, the whole transaction will be rolled back - am I unable to do
> > > this with SPs?
>
> Oooh, how does one answer that? "No, you are not unable to this
> with SPs."
> :-)
> The work of an SP is atomic: nothing that the SP does will get committed
> if the transaction is rolled back.

Double negatives are not always not a gotcha!
Alan