Error in Addattachment | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error in Addattachment

I am Using CDO.Message to send mail from SQL Server. This was working fine in SQL Server 2000 and Windows Server 2000. Recently this was upgraded to SQL Server 2005 and Windows 2003 and noticed that error is occuring in this SP.
After analysing I find that issue with the Addattchment function in the above class. I am getting error
Output values of type Object are not allowed in result sets. —————————————-

It seems that AddAttachment returns an object, but the result set handles strings. You can get around this by executing the procedure and parsing in variables rather than executing the result set. Check out this thread: