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] "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.
>
<< deep sigh >>
It's never easy.
Thanks for your help, you probably saved me a week of looking.
[quoted text, click to view] "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.
> >
Don't see what you're looking for? Try a search.