SQL Mail deprecated in SQL Server 2005 64-bit

SQLMail - Legacy in SQL Server 2005 64-bit

The legacy SQLMail support is no longer available in SQL Server 2005 64-bit. In lower version, i.e. SQL Server 2005 32-bit, SQL Mail is marked as a legacy functionality but you can still setup SQLMail and use it in your Stored Procedures. SQLMail has been superseded by DatabaseMail which does not require MAPI and the installation of Microsoft Outlook to run SQLMail.

Legacy SQLMail in SQL Server 2005

In SQL Server 2005 64-bit we have been advised to use DatabaseMail. This works perfectly for sending e-mails from SQL Server and it’s a whole lot easier when setting up DatabaseMail. The only drawback is you cannot read e-mails from an Outlook mailbox like how you could with SQLMail. Microsoft has not provided an alternative. The only way is to use a third party solution if you want to read e-mails from a mailbox.

In my next post, I will write about a third party solution that will allow you to read e-mails from a mailbox and process the e-mails within SQL Server.