Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 email in sql server 2005

Author  Topic 

dpais
Yak Posting Veteran

60 Posts

Posted - 2010-07-06 : 16:18:16
I want to be able to send an email to my sql server with Subject: INTC 1/1/2003 - 1/1/2010

the sql server should
1. Receive the email
2. dechiper from the email subject line that i want intc stock quote and quotes from to and from date
3. zip the file
4. Create a new reply mail with the zipped up quotes and reply back to the original mail with the new attachment.

i need to know if the email interaction will work with Sql server 2005 or 2008. I can comfortably query, package and prepare the return mail - but can the sql server receive mail ?

thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-06 : 16:56:34
Although I think it is possible to do it in SQL Server 2005 using SQL Mail, specifically xp_readmail, I think you are going down the wrong path. Why does this need to be done via email? A web service sounds like a better solution for this.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -