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
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.