Post reply

Reading Mail With SQL2005

  • January 11, 2008 at 10:31 am

    #180557

    Hi,

    I need to read email with SQL2005. I would use XP_ReadMail but note that it is going to be removed at some future time. Can anyone advise on a safe path to take?

    Thanks

    Stephen

  • January 11, 2008 at 8:15 pm

    #767372

    I have heard that CLR integration is here to stay so that might be a something to consider.

    If retrieving mail via POP3 is an option, create your own CLR stored procedure to read the mail. You could either write your own classes to handle the POP3 communication or use a third-party .NET library to simplify that part of it. Something like this for example: http://www.lesnikowski.com/mail/.

    The assembly would likely need permissions set to EXTERNAL_ACCESS due to it using network resources.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply