I believe (and it has been a while), you can access an email account through some extended stored procedures (xp_readmail and related) in sql (assuming sql is configured right), so you could write a script, have it check the email box, and process right there on the sql box. Just either schedule script to run every so often, or write it such that it loops so it runs continuously.
one caviat is that sql2005 BOL flag it as scheduled for deprecation, and there does not appear to be a replacement for it. On Mon, Jul 7, 2008 at 6:09 PM, Sam Cayze <[EMAIL PROTECTED]> wrote: > I know of one program, email2db, but would like to evaluate some more. > Basically, I need to update some fields in a SQL table when certain emails > arrive. Possible striping of attachments to a folder would be a bonus. > MAPI/Exchange based. > > > > If you are using a product that does this, and you like it, please let me > know, thanks! > > > > Sam > > ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
