opc.three (6/13/2012)
Is is safe to assume your using Standard or Enterprise Edition since you said you have SQL Agent running? i.e. that you are not using Express Edition?If so, then I would recommend using Database Mail instead of cdosysmail.
How to: Configure SQL Server Agent Mail to Use Database Mail (SQL Server Management Studio)
I'm getting a yellow screen on that particular link.
Also, why would you recommend using "Database Mail" instead of CDOSysMail?
--Jeff Moden
Change is inevitable... Change for the better is not.