Emailing query questions

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.
Thanks in advance,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.
"JohnGregor" wrote:
> 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.
> Thanks in advance,|||<< deep sigh >>
It's never easy.
Thanks for your help, you probably saved me a week of looking.
"Wayne Snyder" wrote:
> 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.
>
> "JohnGregor" wrote:
> > 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.
> >
> > Thanks in advance,