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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-20 : 08:57:27
|
| Tammy writes "HiI have a stored procedure that reads sql mail...I only want it to read unread messages...This worked on SQL Server 7 but now that I have moved it to 2000it reads every message!Any ideas?thanksTammyexec master..xp_findnextmsg @msg_id=@hMessage OUTPUT,@unread_only='true'/*while there is a message handle*/while @hMessage is not null" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-20 : 11:04:07
|
| What parameters are you using for xp_readmail, are you sure you're marking the mail as read ? Post more of your code so we can see it in context.HTHJasper Smith |
 |
|
|
|
|
|
xp_findnextmsg &SQL Server 2000