Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

xp_readmail: failed with operating system error 80

Posted on 2004-08-31
11
Medium Priority
?
679 Views
Last Modified: 2008-01-09
Hi, all,

Query:

declare @msg_id varchar(255)
declare @xml nvarchar(4000)
declare @attach nvarchar(4000)
EXEC      master..xp_findnextmsg @msg_id = @msg_id OUTPUT
EXEC      master..xp_readmail    @msg_id = @msg_id,
                               @attachments =      @attach      OUTPUT
print @attach

Result:

Server: Msg 18024, Level 16, State 1, Line 0
xp_readmail: failed with operating system error 80

We keep getting this error. The proc which reads the mail used to work fine but has recently stopped. So, I ran the above query and the error returned is the result.

We are running SQL 2000 sp3.
The SQL Mail user is a domain admin who has access to the Exchange mailbox.
Interestingly, xp_findnextmsg and xp_sendmail both work ok. It's only xp_readmail which fails.

Help pleeeeez!!!

bukko


0
Comment
Question by:bukko
  • 5
  • 4
11 Comments
 
LVL 8

Author Comment

by:bukko
ID: 11941414
...if I could award more points I would, unfortunately 500 is the limit!
0
 
LVL 8

Author Comment

by:bukko
ID: 11941689
Don't worry I fixed it.
You will never know the solution... AH-HAHAHAHAHAHAHAHAHAHA!!!!
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 11941692
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 11941699
0
 
LVL 8

Author Comment

by:bukko
ID: 11941706
I don't know what was wrong, but I deleted the existing mail from the mailbox.
When I sent new mail I was able to process this ok.
0
 
LVL 8

Author Comment

by:bukko
ID: 11941722
itsvtk,

your answers refer to fixing the problem by installing the latest service pack.
As I stated earlier we have sp3 installed.
sp3a only really relates to the setup routine.
0
 
LVL 8

Author Comment

by:bukko
ID: 11941740
...also I already found those sites and they don't help.
Anyway, check my earlier comment - problem over.

Regards

bukko
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 11941811
oh sorry i am still finding the solution on the web without reading your comments....

all the best,
itsvtk

0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 11979655
Closed, 500 points refunded.
CetusMOD
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question