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
ThisTimeNextYearAsked:
Who is Participating?
 
Eugene ZCommented:
check it:
Using SQL Server Table-Valued User-defined Functions with Exchange Web Services
http://msdn2.microsoft.com/en-us/exchange/bb483139.aspx

=======also

there are:
undocumented procs
master:
xp_sysmail_activate
xp_sysmail_attachment_load
xp_sysmail_format_query

and a some in msdb:
e.g. sp_ProcessResponse

http://showcase.geckoware.com.au/sqlscribe/?serverid=3&DatabaseID=4&objecttype=13
----
But
0
 
Eugene ZCommented:
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
0
 
ThisTimeNextYearAuthor Commented:
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.
0
 
ThisTimeNextYearAuthor Commented:
That should do the trick - thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.