Mail syntax interpreted by sp_processmail

Hello
I desperately search for example of mail that can be send to an SQL2000 (SQLMAIL) and executed by the sp_processmail procedure
I really donâ't know how a mail intended to be executed be sp_processmail looks like
Has someone any example
Thank
EricEric,
to get this going is quite straightforward - log onto the SQL Server box
with the same domain user as the SQL Server service. Set up an exchange
profile and set SQL Server to use this profile. From another box, using
another mail profile, send an email to this mailbox with a select statement
in it :
select * from northwind.dbo.region
Back on the SQL box, run sp_processmail.
BOL can explain the intricacies of the sp_processmail syntax, but this
should get you up and going.
HTH,
Paul Ibison|||Thank for your answer Paul, I finally made this work. In fact I was stuck on a outlook 2000 problem with the password not retained for the access of the POP account: http://support.microsoft.com/default.aspx?scid=kb;en-us;25941
B
Eric