April 12, 2007 at 9:37 am
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
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
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