> > On 16-Jun-2004 15:30:09, Alexandre Benson Smith wrote:
> > johnsparrowuk wrote:
> >
> > >It might be better (though more complex) to do it in response to an
> > >event - that way it will only happen on commit.
> > >
> > >A trigger will fire when INSERT takes place (sending the email). But
> > >that could then be rolled back...
> > >
> > >John
> > >
> > >
> > >
> > Agreed !
>
> OK, but how do I do it?
>
> Regards,
> Myles

You cannot do it from the server, nor is it recommended to create and use a
UDF for this. Your best option at this time is to have a separate
application running and listening for the event and firing an email
separately.
Alan