Solved

xp_readmail: failed with operating system error 80

Posted on 2004-08-31
11
667 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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: 11941789
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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

740 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