CDOSYS breaks after removing Outlook Express.

Yep, that will do it.  There is a relationship between CDOSYS and Outlook Express.  So, you should not remove Outlook Express if you ever expect to use CDOSYS or have anything which uses CDOSYS work properly.  Some people get very ambitious about security and start ripping-out software which they don’t think is needed – however,…

1

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