December 20, 2007 at 10:50 am
sp_processmail is deprecated in SS2005.
what is the new method to process incoming email, execute a query, then return the results??
there is a sp_send_dbmail but NO sp_process_dbmail???
thanks for any ideas,
chester
December 26, 2007 at 2:41 pm
Chester,
Appears to be a security risk yet the stored procedure is still in SQL 2005...here is the excerpts from BOL
xp_processmail
Uses extended stored procedures (xp_findnextmsg, xp_readmail, and xp_deletemail) to process incoming mail messages from the inbox for Microsoft SQL Server. Each message is expected to contain a single query in the message body. This procedure uses the xp_sendmail extended stored procedure to return the result set as an attachment to the message sender.
Important:
Avoid using this procedure. The sp_processmail procedure processes information sent to you by mail from unknown sources and can be used to introduce malicious code into your environment. You must take great care to validate the code before executing it. This procedure is included for backward compatibility, but is not installed until you enable SQL Mail.
Note:
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply