Post reply

Query SQL 7.0 Through Exchange

  • August 5, 2002 at 6:31 am

    #57859

    I have read something before that allows a script to be written and place on Exchange which will allow someone to send an email with a SQL statement and the user will be returned the answer.

    This possible??

    Any info or links would be gratefully accepted

    Thanks

    Scott

  • August 5, 2002 at 9:37 am

    #434019

    There are extended stored procedures that link SQL Server to mail (the xp_startmail, xp_sendmail, etc.).

    Some of these include the ability to read mail and you can process the items in the body or subject of the message.

    Personally I think it's a bad idea, but it can be done if you can lock down the security.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • August 5, 2002 at 9:42 am

    #434021

    Thanks Steve...

    What I was looking to do was set a script on Exchange server and have it read the incoming mail and if certain criteria is met it will see it as a SQL Query and responsed back.

    Maybe its more of a Exchange question or CDO script writing.

    Security is an issue for sure, its just that I remember seeing something before SQL Mail was set up on the server here and couldn't find the link anymore.

    Thanks for your time

    Scott

  • August 5, 2002 at 10:17 am

    #434033

    I'm sure Exchange can do this, but that would be some complicated scripting on the Exchange side. Try Admin911 (mitch Kupcheck) or Swynk and see if they've got something.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • August 5, 2002 at 10:26 am

    #434035

    Thanks again...

    I'm on my way to the sites....

    Scoitt

Viewing 5 posts - 1 through 4 (of 4 total)

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