all groups > sql server reporting services > february 2007 >
You're in the

sql server reporting services

group:

Emailing query questions



Emailing query questions JohnGregor
2/28/2007 3:57:10 PM
sql server reporting services: Hello,

I am very new to sql server (as in, still reading the table of contents in
the big honkin' book I bought).

is there a way for users to send an inquiry to an email address, and get a
response from sql server? It would be very helpful if someone could send an
email to parts@##.com with a part number in the header, and get an email in
response with information on that part.

I also have exchange server 2003, if that helps.

RE: Emailing query questions Wayne Snyder
3/5/2007 6:18:03 AM
I do not know a way in SQL 2005 other than custom coding...

In SQL 2000 there was a stored procedure sp_processmail which could do what
you ask - but you shouldn't use it in new dev because it is going away...

--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


[quoted text, click to view]
RE: Emailing query questions JohnGregor
3/5/2007 10:12:30 AM
<< deep sigh >>

It's never easy.

Thanks for your help, you probably saved me a week of looking.



[quoted text, click to view]
AddThis Social Bookmark Button