Send mail TO sql server and get result back...

• Dennis-509860

  Old Hand

  Points: 351

  More actions

  August 3, 2009 at 1:04 am

  #140351

  Hi all, I have Database Mail up and running on a SQL 2008 server and everything works great. But what I want to set up is a way for people to send queries TO the server and get a result back. Is this possible that a SQL Server can receive email, run the query in the body, and send the result back?

  Thanks!

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 3, 2009 at 8:04 pm

  #1034028

  This was possible in SQL Server 2000 using SQLMail, but I have not found any way at this time to do so with DatabaseMail.

  I think it may have been considered a security hole as there was no real way to validate the code before it was executed which could leave a database vulnerable to SQL Injection type attacks.

• Lowell

  SSC Guru

  Points: 323518

  More actions

  August 3, 2009 at 8:11 pm

  #1034031

  Lynn's point on security is a good one; I would think it might be possible with CLR, but I'm not sure; there are a lot of objects that you cannot add to a SQL CLR project.

  maybe instead of email you might consider a web service or an EndPoint to return specific data?

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Dennis-509860

  Old Hand

  Points: 351

  More actions

  August 4, 2009 at 12:33 am

  #1034084

  Yeah, you're right about security. The reason I brought it up was that I vaguely remember doing something like this in SQL 2000, but I couldn't find it in 2008. That probably explains it. Thanks.