Read mail message with Database Mail

I have a need to read email being sent to an account. This is fairly easy
using SQL Mail, but I want to use the Database Mail provided with SQL 2k5 (a
s
SQL Mail is being phased out).
Is there a way to read mail as well as send, or is it a send only process?
Thanks!Send only. It is basic SMTP functionality.
"RC" <RC@.discussions.microsoft.com> wrote in message
news:54A67B68-CED4-426B-8DFD-7EA8900C3B12@.microsoft.com...
>I have a need to read email being sent to an account. This is fairly easy
> using SQL Mail, but I want to use the Database Mail provided with SQL 2k5
> (as
> SQL Mail is being phased out).
> Is there a way to read mail as well as send, or is it a send only process?
> Thanks!|||So in the future is this functionality going to be CLR only or is there goin
g
to be a new way to read email?
The situation boils down to company-based security difficulties in setting
up a FTP location for an external company to drop a file, but picking up an
email with the file attached is a solution I could work through.
Thanks again!
"Aaron Bertrand [SQL Server MVP]" wrote:

> Send only. It is basic SMTP functionality.
>
> "RC" <RC@.discussions.microsoft.com> wrote in message
> news:54A67B68-CED4-426B-8DFD-7EA8900C3B12@.microsoft.com...
>
>|||For what it's worth, there are several different APIs (like the Exchange OLE
DB Provider) for pulling data from Exchange Server:
http://msdn.microsoft.com/library/d...ytechnology.asp
"RC" <RC@.discussions.microsoft.com> wrote in message
news:54A67B68-CED4-426B-8DFD-7EA8900C3B12@.microsoft.com...
>I have a need to read email being sent to an account. This is fairly easy
> using SQL Mail, but I want to use the Database Mail provided with SQL 2k5
> (as
> SQL Mail is being phased out).
> Is there a way to read mail as well as send, or is it a send only process?
> Thanks!|||> So in the future is this functionality going to be CLR only or is there
> going
> to be a new way to read email?
Well, SQL Mail still exists. I don't think database mail was meant tobe a
complete swap-out replacement for SQL Mail, it was meant as an additional
feature. 99% of the installations I have seen use SQL Mail ONLY for
outgoing mail, so database mail is a much quicker and easier to configure
way to get there.
A|||I agree with Aaron that vast majority of installations that uses mail from S
QL Server only uses it
to send email.
Thing is with Database Mail is that it is SMTP (which is also the upside), a
nd SMTP is receiving
email only. If you feel that receiving email in SQL Server is very important
to you, you might want
to say so at http://lab.msdn.microsoft.com/productfeedback/
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"RC" <RC@.discussions.microsoft.com> wrote in message
news:74C9C105-2752-44CE-BCB4-D1F592447363@.microsoft.com...
> So in the future is this functionality going to be CLR only or is there go
ing
> to be a new way to read email?
> The situation boils down to company-based security difficulties in setting
> up a FTP location for an external company to drop a file, but picking up a
n
> email with the file attached is a solution I could work through.
> Thanks again!
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>|||If these files are highly sensitive or more than a couple of MB in size,
then receiving them as an attachment via email would also present problems.
"RC" <RC@.discussions.microsoft.com> wrote in message
news:74C9C105-2752-44CE-BCB4-D1F592447363@.microsoft.com...
> So in the future is this functionality going to be CLR only or is there
> going
> to be a new way to read email?
> The situation boils down to company-based security difficulties in setting
> up a FTP location for an external company to drop a file, but picking up
> an
> email with the file attached is a solution I could work through.
> Thanks again!
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>