li************@fmc-na.com (lhansen) wrote in message news:<c3**************************@posting.google. com>...
I have a SQL Server 2000 application that send's e-mail to users using
the xp_smtp_sendmail procedure. That works fine. What I would like
to do is RECIEVE e-mail with SQL Server.
Example: I text message an alert to a user. They reply with some
keyword in the subject of their reply e-mail, such as 'ACKNOWLEDGED'
or 'ACK' for short. SQL Server recieves this and then acts upon it
with a stored procedure, etc.
Anyone know if this is possible and with what tool?
TIA,
Lindsey
If you set up SQL Mail, you can use sp_processmail to handle incoming
emails. Although if you're using xp_smtp_sendmail, then presumably SQL
Mail may not be an option for you.
Although I don't know of an existing tool, it should be relatively
easy to write a script which connects to a mailbox, parses the emails
and then connects to SQL Server to do something there. You can then
schedule it to run at a suitable interval (every 5 minutes or
whatever), or make it into a service.
Simon