September 22, 2009 at 4:44 pm
To send an email to a specific email address I've succeeded,
now I'm confused how I want to know there are replies or not in your inbox.
How do I order so I can take all the existing email in the inbox using a query?
Thanks for advise,
Eko Indriyawan
September 22, 2009 at 5:13 pm
I think MSSQLServer2008 can not do that.
cheers,
Liasie
September 22, 2009 at 7:52 pm
SQL 6.5 could do something but not really what you are asking for..
I have to ask a different question.
SQL isn't really meant to read email and interpret it.. There is no capacity for SQL to read an inbox. There are several different kinds of inboxes such as POP3 or IMAP4. It would make a lot more sense to build an app or service to read any responses, interpret them, and then make database calls.
There is a way using SQLCLR but in the strongest terms I recommend against it.
CEWII
September 22, 2009 at 8:11 pm
Hello Elliott,
Can you give me an example of a query to read the email in MS SQL Server 2008?
King regards,
Eko Indriyawan
September 22, 2009 at 9:04 pm
There isn't a query.
You'd have to write it in .NET to make it happen, so no, I can't give you a query..
CEWII
September 22, 2009 at 10:01 pm
Elliott W (9/22/2009)
There isn't a query.You'd have to write it in .NET to make it happen, so no, I can't give you a query..
CEWII
How about sp_processmail or xp_readmail ?
September 22, 2009 at 10:51 pm
Maybe for SQL Mail.
And a warning from BOL "This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature."
Database Mail resolves all the known issues with SQL Mail. SQL Mail was ALWAYS a disaster, and you should not be using it.
As a simple point, you can setup SQL Mail but you shouldn't, you can do this in the database but you shouldn't.
I'm sorry, but I won't be responding further.
CEWII
September 23, 2009 at 2:21 am
Elliott W (9/22/2009)
Maybe for SQL Mail.And a warning from BOL "This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature."
Database Mail resolves all the known issues with SQL Mail. SQL Mail was ALWAYS a disaster, and you should not be using it.
As a simple point, you can setup SQL Mail but you shouldn't, you can do this in the database but you shouldn't.
I'm sorry, but I won't be responding further.
CEWII
Thank you very much,
From the post that you gave,
I became better know the reason
from the developer to eliminate the feature
Now I just use SQLMail only to send a message
related to the problem of automation of information systems.
For the purpose of send and receive messages outside
the system of information, I will make their own applications
like outlook. I will use the component add-in express to create
the program. It is better to process send and receive messages,
we manage the message in a special database, separate from
the database information system.
king regards,
Eko Indriyawan
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply