Hi
If I run the following in Query Analyser, everything is OK and I
receive the query results on my client PC mailbox:
However if I e-mail the same query to SQL2000 (with Outlook 2000 as
mail client) and run the following in Query Analyser
exec sp_processmail
I get the following results:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
Queries processed: 0.
The mail message still appears 'unread' in Outlook. If I run the
following in Query Analyser
exec xp_readmail
it returns the following:
Ian Hingley
NULL NULL test sql
number of
pubs.dbo.authors' true NULL
0x00000000A00100F5D905D61182940004ACA6E0F1240E2000 IPM.Note
implying it can 'see' the mailbox OK. The mail message then appears
'read' in Outlook.
Any ideas what I'm doing wrong?
Thanks
Ian Hingley