dbfc
asked on
Microsoft, SQL, 2005, SQL2005
I receive the error 'Procedure expects parameter @user, which was not supplied.'
when I attempt to run sp_mail using the following
EXEC master.dbo.xp_sendmail
@recipients=N'danw@Adventu re-Works.c om',
@message=N'The master database is full.' ;
xp procedures are enabled and the test emails are sent without an issue. I have seen this issue posted on many forums but have yet to find a solution that resolves the issue. Thanks in advance for assistance.
when I attempt to run sp_mail using the following
EXEC master.dbo.xp_sendmail
@recipients=N'danw@Adventu
@message=N'The master database is full.' ;
xp procedures are enabled and the test emails are sent without an issue. I have seen this issue posted on many forums but have yet to find a solution that resolves the issue. Thanks in advance for assistance.
ASKER
Thanks but I have already investigated the thread you suggested and it's a dead end.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the recommendation. I have gone the route you suggested to resolve the issue.
Not one I've seen myself, so apologies if you've already seen this:
Implies something to do with mapi/sql mail profile instead of xp_sendmail or the parameters you're passing to it:
http://www.mydatabasesupport.com/forums/ms-sqlserver/154450-xp_sendmail-procedure-expects-parameter-user-not.html