Query to retrieve emails in the inbox

Question

Post reply

Query to retrieve emails in the inbox

eko indriyawan

Hall of Fame

Points: 3316
More actions
September 22, 2009 at 4:44 pm

#210031

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

liasie Valued Member Points: 53 More actions · Answer 1

I think MSSQLServer2008 can not do that.

cheers,

Liasie

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

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

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 3

Hello Elliott,

Can you give me an example of a query to read the email in MS SQL Server 2008?

King regards,

Eko Indriyawan

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

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

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 5

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 ?

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 6

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

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 7

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