Solved

xp_readmail: failed with operating system error 80

Posted on 2004-08-31
11
670 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

623 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