SQL 2005 Database Mail - sp_processmail

Posted on 2007-08-01
Last Modified: 2008-01-09

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?

Question by:ThisTimeNextYear
    LVL 42

    Expert Comment

    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

    Author Comment

    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.
    LVL 42

    Accepted Solution

    check it:
    Using SQL Server Table-Valued User-defined Functions with Exchange Web Services


    there are:
    undocumented procs

    and a some in msdb:
    e.g. sp_ProcessResponse

    Author Comment

    That should do the trick - thanks

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now