I am trying to use the xp_sendmail feature of SQL Server 2005 (64 bit) running on Windows 2003 server. Unfortunately here's what it complains when trying to execute it: SQL Mail does not work with the 64-Bit version of SQL Server. What will be my other alternative? Appreciated some input. Thanks,
Service Pack 1 fixed this for DB Mail. I was just looking at http://blogs.msdn.com/sanchan/archive/2006/04/23/581639.aspx which says this. See http://msdn2.microsoft.com/en-us/library/ms187891.aspx for SQL Mail to DB Mail conversion, this is what you want to use in SQL 2005. General how-to setup database mail: http://msdn2.microsoft.com/en-us/library/ms188298.aspx -Chuck Lathrope
I am using dbmail which uses SMTP instead of MAPI without any issues... Follow the links provided by Chuck... What is your sql build ?
Thanks for the email. I am running SQL 2005 with SP1. Let me see, if SP2 is available for this platform. if yes, then i shall download and apply SP2.
Thanks for that sp2 link. Has anyone found out how to customize? Article says: "You can now customize parameters that are passed to DatabaseMail90.exe"