Post reply

SQL Server 2005 to automatically check for and retrieve emails from a POP3 server

  • May 1, 2009 at 11:04 am

    #133830

    Is it possible to configure SQL Server 2005 to automatically check for and retrieve emails from a POP3 server and store them in the database in a configurable manner. and then retrieve them as needed from applications which use the database.

    If anyone can point out some reading, either online or in the MSDN library that would be great.

    Thanks.

  • May 1, 2009 at 11:56 am

    #987477

    There is an extended stored procedure called xp_readmail which I looked at a long time ago but never tried to implement. It looks like they are trying to remove it post 2008 but it is still available. Worthy of looking into.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • May 1, 2009 at 4:14 pm

    #987626

    Part of the issue here is that this could be a security hole. You don't necessarily want to have an XP reading mail.

    What you might want to do is have a .NET application read stuff and then insert it into a table.

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

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