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

is it a good idea to keep sql server with mail server on single T1

hello everyone!!!!!!!!
I just wanted to know is it a good idea to keep both mail and databse server
on same T1.if yes then plz tell me why.
Waiting for yr help.if you could have any documentation on this plz let me
know.
Thanks in advance for yr help.
Bharat.Hi Bharat
This depends on what you are doing with the mail, for instance if you are
using SQL Mail or SMTP.
Having the the mail server or a relay nearby will help reduce the time it
takes to send the mail, which would be very important if you are sending
synchronous emails for instance (for example if in some fit of madness you
decided to send emails from within triggers).
I have not seen any documentation on this but the advice gained by
experience has been posted in the past by others.
John
"bharat" <bharat@.discussions.microsoft.com> wrote in message
news:AECB5C4E-1EEA-479C-B247-291017A552DA@.microsoft.com...
> hello everyone!!!!!!!!
> I just wanted to know is it a good idea to keep both mail and databse
> server
> on same T1.if yes then plz tell me why.
> Waiting for yr help.if you could have any documentation on this plz let me
> know.
> Thanks in advance for yr help.
>
> Bharat.|||bharat wrote:
> hello everyone!!!!!!!!
> I just wanted to know is it a good idea to keep both mail and databse server
> on same T1.if yes then plz tell me why.
For most serious production systems it is a bad idea to have them on the
same machine there is just too much coupling / dependency - performance
wise as well as liveness wise.
> Waiting for yr help.if you could have any documentation on this plz let me
> know.
You don't really need documentation - just think a bit about it for a
moment.
Kind regards
robert|||No --I feel
why? It depends
.How busy you database server is? OLTP or DSS
.Number of User's(concurrent user's) expected on database
.Hardware consideration can be one aspect to look in to
If u have Multiple CPU machine/server with gig's og memory enough to
suffice SQL Server requirement.go ahead u can have Mail on the same machine
Thanks
"bharat" wrote:
> hello everyone!!!!!!!!
> I just wanted to know is it a good idea to keep both mail and databse server
> on same T1.if yes then plz tell me why.
> Waiting for yr help.if you could have any documentation on this plz let me
> know.
> Thanks in advance for yr help.
>
> Bharat.

is it a good idea to keep sql server with mail server on single T1

hello everyone!!!!!!!!
I just wanted to know is it a good idea to keep both mail and databse server
on same T1.if yes then plz tell me why.
Waiting for yr help.if you could have any documentation on this plz let me
know.
Thanks in advance for yr help.
Bharat.Hi Bharat
This depends on what you are doing with the mail, for instance if you are
using SQL Mail or SMTP.
Having the the mail server or a relay nearby will help reduce the time it
takes to send the mail, which would be very important if you are sending
synchronous emails for instance (for example if in some fit of madness you
decided to send emails from within triggers).
I have not seen any documentation on this but the advice gained by
experience has been posted in the past by others.
John
"bharat" <bharat@.discussions.microsoft.com> wrote in message
news:AECB5C4E-1EEA-479C-B247-291017A552DA@.microsoft.com...
> hello everyone!!!!!!!!
> I just wanted to know is it a good idea to keep both mail and databse
> server
> on same T1.if yes then plz tell me why.
> Waiting for yr help.if you could have any documentation on this plz let me
> know.
> Thanks in advance for yr help.
>
> Bharat.|||No --I feel
why? It depends
.How busy you database server is? OLTP or DSS
.Number of User's(concurrent user's) expected on database
.Hardware consideration can be one aspect to look in to
If u have Multiple CPU machine/server with gig's og memory enough to
suffice SQL Server requirement.go ahead u can have Mail on the same machine
Thanks
"bharat" wrote:

> hello everyone!!!!!!!!
> I just wanted to know is it a good idea to keep both mail and databse serv
er
> on same T1.if yes then plz tell me why.
> Waiting for yr help.if you could have any documentation on this plz let me
> know.
> Thanks in advance for yr help.
>
> Bharat.