Solved

xp_readmail: failed with operating system error 80

Posted on 2004-08-31
11
664 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

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…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

776 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