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:
>

Read and Delete Mail in SQL 2005

Does anyone have script or a CLR assembly to read and delete email in
SQL2005? I don't want to enable SQL mail or install Outlook.
Thanks in advance
Terry
Hi
You may want to check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncodefun/html/code4fun03282003.asp
John
"Terry" wrote:

> Does anyone have script or a CLR assembly to read and delete email in
> SQL2005? I don't want to enable SQL mail or install Outlook.
> Thanks in advance
> Terry
>

Read and Delete Mail in SQL 2005

Does anyone have script or a CLR assembly to read and delete email in
SQL2005? I don't want to enable SQL mail or install Outlook.
Thanks in advance
TerryHi
You may want to check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncodefun/html/code4fun03282003.asp
John
"Terry" wrote:
> Does anyone have script or a CLR assembly to read and delete email in
> SQL2005? I don't want to enable SQL mail or install Outlook.
> Thanks in advance
> Terry
>

Read and Delete Mail in SQL 2005

Does anyone have script or a CLR assembly to read and delete email in
SQL2005? I don't want to enable SQL mail or install Outlook.
Thanks in advance
TerryHi
You may want to check out
http://msdn.microsoft.com/library/d...fun03282003.asp
John
"Terry" wrote:

> Does anyone have script or a CLR assembly to read and delete email in
> SQL2005? I don't want to enable SQL mail or install Outlook.
> Thanks in advance
> Terry
>

rdl generator

hi all
i m in need of a report definition language generator
is there anyone who can suggest some download links
or if u have it u can plss mail it to me
senzy_phil@.yahoo.comOn Sep 21, 4:46 pm, "sammy123" <u37530@.uwe> wrote:
> hi all
> i m in need of a report definition language generator
> is there anyone who can suggest some download links
> or if u have it u can plss mail it to me
> senzy_p...@.yahoo.com
Here are a couple links that provide similar functionality.
http://msdn2.microsoft.com/en-us/library/aa337503.aspx
http://www.codeproject.com/csharp/RdlProject.asp
http://www.jaspersoft.com/re_faq.html
Of course, if you create a couple of reports and then evaluate the XML
code in the files themselves, you should be able to create the RDL
files via C#.NET/VB.NET using streamreaders/streamwriters. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant