Improve company productivity with a Business Account.Sign Up

x
?
Solved

xp_readmail: failed with operating system error 80

Posted on 2004-08-31
11
Medium Priority
?
684 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
10 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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
During the weekend, I was asked to investigate into a deadlock in SQL Server 2014. SQL being something I don’t really fancy myself being an expert at, I had to do some refreshing. This article is a collection of my notes.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

595 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