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)
 SQL Mail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-06 : 17:44:12
DAVID writes "Dear Guru

Many Thanks for the SQLMail article, However I’ve got a couple of queries

xp_readmail without params returns everything, which is great – but the MessageID’s seem to be varbinary and can’t be used as @msg_id with xp_readmail (To mark successfully processed mails as read etc.


xp_findnextmsg Never returns a NULL ID, it returns the Id it was given if there are no further messages, except if it is set @Unread_Only = true, then it just returns the same ID no matter what!!


Please help me, I am crying as I write this…

win2K and sqlServer2000"
   

- Advertisement -