October 14, 2007 at 9:38 am
I am examing the options to use sql 2005 server to read incoming email, then insert records into a table.
Here is the order of events:
1. SQL server generates an email to send out to specific users in the system.
2. The users receive the email, add in some text, then respond.
3. The sql server then reads the email and inserts the responses into the appropriate table.
I have currently setup dbmail on a test server, and the email can be generated and sent out ok.
I have done some work with sharepoint 2007 server, which is where I got this concept. In the sharepoint server, people can email directly to a list, and it will post without having to log into anything special, either a site on the sharepoint server, or a custom site.
So, I am looking at some options that are similar. I have been reading about certain sp procs not being supported in the next release, so I am not sure that is the way to go. I have also been reading using the service broker.
Any suggestions or comments would be appreciated.
Thanks
October 14, 2007 at 10:01 am
I hate reading mail in SQL Server, but that's for processing queries. You don't want anyone to submit queries through mail as it opens you up for security issues.
If you're just reading and inserting data, you should be able to use the procs to read mail and parse out what you want. Not sure if they'll be removed, but I hadn't heard that.
Your process should work. Depends on the level of parsing from what users put in. Any reason not to have a small app for people to input stuff in?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply