Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: sp_processmail - driving me nuts!

    I have two different SQL server installations (7 and 2000) that I have configured for using the SP_processmail procedure. Both servers can properly execute xp_startmail, xp_stopmail, xp_readmail, and xp_findnextmsg. HOWEVER, both have different problems with SP_processmail.

    Using this command (and a host of many other variations):
    sp_processmail @filetype = 'CSV', @separator = ',', @dbuse = 'ryantest', @set_user = 'guest'

    SQL 7.0 says: Server: Msg 18007, Level 16, State 1, Line 0
    Supplied datatype for @set_user is not allowed, expecting 'varchar'

    I have tried every variation possible, including not specifying the yser which should result in it defaulting to the "guest" account. The message is always the same.

    SQL 2000 says: Server: Msg 18025, Level 16, State 1, Line 0
    xp_sendmail: failed with mail error 0x80004005
    Queries processed: 0.

    I have checked all my configurations and read every KB article - I can't find anything wrong.

    Can someone PLEASE respond if you have any experience with SP_PROCESSMAIL on your servers.

    Thanks in advance.

    Ryan Hunt

  2. #2
    Join Date
    Aug 2003

    Re: sp_processmail - driving me nuts!

    I found the problem with the SQL 7.0 server. There is a bug in the SP_PROCESSMAIL procedure. Two data types need to be changed. They are:
    @set_user varchar(128)='guest',
    @dbuse varchar(128)='master'

    Here is a link to the KB article.;en-us;239074

    Any ideas on the SQL 2000 server would be appreciated.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts