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?