SP_PROCESSMAIL

• rhunt

  SSCertifiable

  Points: 5868

  More actions

  March 25, 2004 at 1:05 pm

  #160786

  I am having a problem getting the SP_PROCESSMAIL procedure to work on my SQL 7.0 box.

  I have a mapi client setup and a valid mailbox for the services account.  XP_STARTMAIL works correctly.

  However, when I execute:  exec sp_processmail I get an error stating:

  Server: Msg 18007, Level 16, State 1, Line 0

  Supplied datatype for @set_user is not allowed, expecting 'varchar'

  If I enter in a user to execute as, I still get the same answer. For example:

  execute sp_processmail @set_user = 'rhunt'

  or

  execute sp_processmail @set_user = rhunt

  both get the same error...the exact same error as above.  I checked the stored procedure and it is looking for sysname???  Does anyone have any experience with this stored procedure on SQL 7.0?

  Thanks in advance.

  Ryan

• Sopheap Suy

  SSCertifiable

  Points: 7893

  More actions

  March 25, 2004 at 4:35 pm

  #500515

  I am wondering what if you left off that @set_user option?  does your stuff work?

   

  in sql 7.0 master here is how it is defined:

  create procedure sp_processmail --- 1996/06/19 17:30

   @subject varchar(255)=NULL,

   @filetype varchar(3)='txt',

   @separator varchar(3)='tab',

   @set_user sysname='guest',

   @dbuse sysname='master'

   

   

  mom

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 26, 2004 at 5:41 am

  #500619

  From BOL

  Is the security context in which the query should be run. user is sysname. If user is not specified, the security context defaults to that of the user executing xp_sendmail.

   

  Maybe you shoud check the security context of xp_sendmail. Under wich account, runs SQL. With wath rights?