asked on

SQL 2005 Database Mail - sp_processmail

Hi,

I have been tasked with upgrading a SQL 2000 DB to 2005. One of the tasks the 2000 db does is send and receive emails. I'm sending mail fine with 2005, but there doesn't seem to be any way to receive emails since Microsoft has deprecated the old SQL Mail sp_processmail and sp_readmail stored procedures.

Quote from MSDN... "This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature."

That is fair enough, but they don't tell us what to use instead of sp_processmail.

Can anybody help please?

Thanks

EugeneZ

try to Use Service Broker to process email in SQL Server 2005

check article below:
Use Service Broker Internal Activation in SQL Server 2005
by Tim Chapman

http://articles.techrepublic.com.com/5100-9592_11-6156264.html

ThisTimeNextYear

ASKER

Thanks for your answer, Service Broker / sql messaging is definitely the way ahead once the email has been received.

What this article doesn't explain is how to replicate the reading and processing of emails that was available in SQL 2000 but is unfortunately not available in 2005.

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ThisTimeNextYear

ASKER

That should do the trick - thanks