April 17, 2002 at 1:33 pm
Does anybody have any examples of an email they would send to a SQL Server to be processed? I am trying to query some databases and it is not processing correctly.
-JG
-JG
April 17, 2002 at 2:46 pm
Check 'MAIL' category in the Sripts ('http://www.sqlservercentral.com/scripts/listscripts.asp?CategoryNm=Mail&Categoryid=2')
April 17, 2002 at 3:06 pm
I looked in the script library, but came up empty handed. Was there a scecific script you were refering to that show how to process incoming mail queries?
-JG
-JG
April 19, 2002 at 9:12 am
quote:
Was there a scecific script you were refering to that show how to process incoming mail queries?-JG
No, I just thought may be you can find something useful over there.
I have experience with sending e-mail from the server with the resuls of the query, not the other way.
May be you want to look into sp_processmail (T-SQL)that doing both incoming and outgoing processes.
April 19, 2002 at 9:53 am
This is what I am doing:
I create s imple queyr in an outlook msg body.
Select * from <atable>
I send it to the Sql Account.
I go to QA and execute sp_processmail and I get O queries processed.
I was wandering if I am missing some syntax on one of the ends or if I am doing this functions completly wrong.
-JG
-JG
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply