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 |
|
Kanati
Starting Member
36 Posts |
 Posted - 2004-09-14 : 16:30:34
|
SQL Mail is up and running... And I can use xp_sendmail just fine. I send emails left and right. Sometimes we have as many as 200+ emails go out per day. But now I'm trying to read and parse down some emails being sent to the account that is set up for SQL Mail. When I manually use xp_findnextmsg or sp_processmail it doesn't find any mail to process however.DECLARE @status int, @message_id varchar(255)EXEC @status = xp_findnextmsg @msg_id = @message_id OUTPUTPRINT @message_idPRINT @status That's the code I used (along with some other code, but that should do for now). It returns a null string in @message_id and 0 in @status. There are 3 unread messages in the inbox on the profile in Outlook, and a couple of messages sitting on the email server as well. If it matters, outlook is running on the server while trying this as well.Kanati |
|
|
Kanati
Starting Member
36 Posts |
Posted - 2004-09-15 : 10:43:06
|
| BUMP! shimmy shimmy shake! Bump ba dump bump! |
 |
|
|
|
|
|
sp_processmail and xp_readmail problems