Solved

Microsoft, SQL, 2005, SQL2005

Posted on 2008-10-23
4
266 Views
Last Modified: 2010-04-21
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@Adventure-Works.com',
    @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.


0
Comment
Question by:dbfc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 23

Expert Comment

by:adathelad
ID: 22790969
Hi,

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
0
 

Author Comment

by:dbfc
ID: 22790998
Thanks but I have already investigated the thread you suggested and it's a dead end.
0
 
LVL 6

Accepted Solution

by:
bcsql earned 250 total points
ID: 22791331
Just a little suggestion use database mail and not SQL mail. SQL mail is the old sql 2000 mail and it not very reliable. Use SQL 2005's database mail and use sp_send_dbmail. That way you do not have to have the outlook client on the db server.

Every time i see this error it has to do with SQL mail messing up. You can try to stop and start sql mail with, xp_startmail and xp_stopmail. I have even had to bounce the box to fix it.

Also open outlook and double check you profile and user are correct.
0
 

Author Closing Comment

by:dbfc
ID: 31509445
Thanks for the recommendation.  I have gone the route you suggested to resolve the issue.
0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Isolation level in SQL server 3 58
SQL Restore Script - Syntax Error 8 115
date diff with Fiscal Calendar 4 83
Trying to understand why my Index is so large 12 47
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

731 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question