Recently I got email from one of the blog reader that he is getting below error while setting up SQL MAIL as legacy feature in SQL Server 2008.
Error:
SQL Mail does not work with the 64-bit version of SQL Server (Microsoft SQL Server, Error: 17938)
Solution:
SQL Mail is not supported on 64-bit versions of SQL Server. SQL Mail stored procedures cannot be installed on 64-bit versions. If you want to still use it you have to go with the 32-bit edition or start using database mail, which is more easy.
Follow below article link to start converting your SQLMAIL to DB Mail.
http://msdn.microsoft.com/en-us/library/ms187891.aspx
