Is it Possible to download mails?

Hi,
I have a mail box in one machine. I just want to download all the mails
from that machine to the server which is running SQL Server 2000 and store
them in the database. Is this Possible? If so, let me know how this can be
done efficiently.
I would like to download mails automatically from that machine to the
server whenever the mails arrive.
Regards,
Sevugan.CYOu could use the XP xp_readmail, descriptions are written in the BOl for
that. For further control over the mails you should use another technology,
like something coding on your own in .NET to query the mailbox with Webdav
or something like that.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Sevugan" <Sevugan@.discussions.microsoft.com> schrieb im Newsbeitrag
news:DBD4354E-5A4A-4B1E-8747-CBF0FF913C95@.microsoft.com...
> Hi,
> I have a mail box in one machine. I just want to download all the mails
> from that machine to the server which is running SQL Server 2000 and store
> them in the database. Is this Possible? If so, let me know how this can be
> done efficiently.
> I would like to download mails automatically from that machine to the
> server whenever the mails arrive.
> Regards,
> Sevugan.C|||Hi,
xp_readmail Reads a mail message from the Microsoft? SQL Server? mail
inbox. How do I bring all the mails from the mail client(Microsoft Outlook)
to
sql server mail box. How can I see the mails in the SQL Server mail box.
Can u give me a small examle? This will be very helpful for me.
I am new to SQL Server mails.
Regards,
Sevugan.C
"Jens Sü?meyer" wrote:

> YOu could use the XP xp_readmail, descriptions are written in the BOl for
> that. For further control over the mails you should use another technology
,
> like something coding on your own in .NET to query the mailbox with Webdav
> or something like that.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Sevugan" <Sevugan@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:DBD4354E-5A4A-4B1E-8747-CBF0FF913C95@.microsoft.com...
>
>|||HI
Well I have an idea but i am not sure about this.
1)I think you can use the mail component and write a code or a script to
retrieve mails from the machine and make connectivity to the SQL server and
store your mails in the database
2) you can also use SQL DMO to connect to SQL Server and store your mails in
the database.
"Sevugan" wrote:

> Hi,
> I have a mail box in one machine. I just want to download all the mails
> from that machine to the server which is running SQL Server 2000 and store
> them in the database. Is this Possible? If so, let me know how this can be
> done efficiently.
> I would like to download mails automatically from that machine to the
> server whenever the mails arrive.
> Regards,
> Sevugan.C|||Maybe this will help !
You can connect on you server with the same credential than SQL Server,
then check mail !
Pollus Brodeur|||I have started a mail session. I used xp_findnextmsg to get the next
message id.
when I executed the below statement.
EXEC xp_readmail '0x04B72100' it keeps on executing. I am not getting any
response from the server. What could be the problem.
How could I resolve this?
Sevugan.C
"Jens Sü?meyer" wrote:

> YOu could use the XP xp_readmail, descriptions are written in the BOl for
> that. For further control over the mails you should use another technology
,
> like something coding on your own in .NET to query the mailbox with Webdav
> or something like that.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Sevugan" <Sevugan@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:DBD4354E-5A4A-4B1E-8747-CBF0FF913C95@.microsoft.com...
>
>