Post reply

Database Mail,sp_sysmail_activate ''Invalid Parameter''

  • April 12, 2007 at 9:37 am

    #173411

    I am receiving the following error in the SQL Server error log when trying to send an email via Database Mail:

    The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'Error executing extended stored procedure: Invalid Parameter'

    I haven't been able to find anything about this stored procedure. I ran trace/profiler in order to try to capture what parameters were being passed to this stored proc however I don't see the stored proc at all in the trace.

    Has anyone else encountered this issue ? Any help is greatly appreciated - Thank you.

  • April 12, 2007 at 9:47 am

    #700141

    Make sure db mail is enabled on the server... (from BOL):

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Database Mail XPs', 1;

    GO

    RECONFIGURE

    GO

  • April 12, 2007 at 11:14 am

    #700170

    database mail is enabled and has been - we still encounter the error

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply