Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1213
  • Last Modified:

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
0
ThisTimeNextYear
Asked:
ThisTimeNextYear
  • 2
  • 2
1 Solution
 
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
 
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
 
ThisTimeNextYearAuthor Commented:
That should do the trick - thanks
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now