Cleaning mailbox

[h1234]

declare @hMessage varchar(255)
exec master..xp_findnextmsg @msg_id=@hMessage OUT
while @hMessage is not null
begin
exec master..xp_deletemail @hMessage
exec master..xp_findnextmsg @msg_id=@hMessage OUT
end
----------------------------------------------------
This code delete only one message (the first), why?

 

[yearnings]

Hi h1234,

I Know little about SQLMail, but I think
your script should be:

declare @hMessage varchar(255)
exec master..xp_findnextmsg @msg_id=@hMessage OUT
while @hMessage is not null
begin
exec master..xp_deletemail @hMessage
exec master..xp_findnextmsg @msg_id=@hMessage OUT
CONTINUE
end

 

[h1234]

"CONTINUE" is unhelpfull in this case