Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 xp_findnextmsg problem!

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-14 : 09:20:34
Andrew writes "The following code displays no value for @hMessage even though there are three e-mails waiting in the in-box. I've read that Microsoft recognise this as a problem prior to Service Pack 1 on SQL Server 2000 but we already have this installed. Any ideas?

DECLARE @hMessage varchar(255)

EXEC xp_findnextmsg @msg_id=@hMessage OUT

select @hMessage"
   

- Advertisement -