> I'm trying to work out if I can setup a transaction within a stored
> procedure, or if this has to be done before the stored procedure is
> executed?
>
> Myles
>

Starting/Stopping transactions are client activites. You also have
savepoints at the server.
Alan