this sounds typical for M$ - overload the backend with rarely used functionality :)
I think this can be much more elegant be done outside the DB with a host language. For example with any script language where is should not cover more then a few lines.
You can even trigger this from DB if this is desired.
Regards Tino
PS: if code example is needed, I can provide.
Pavel Stehule wrote:
Hello
you have to find xp_sendmail.
PS
xp_sendmail
Sends a message and a query result set attachment to the specified recipients.
...
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
