Why is CDOSYS failing in a stored procedure?

If you’re experiencing issues with CDOSYS under a stored procedure, you may be running into one of the issues I’ll mention here.      Outlook is usually installed on SQL Servers in order to provide mail sending capability (using xp_sendmail).  However, xp_sendmail does not work in a cluster configuration. So CDOSYS is used from a stored procedure…

1