Solved

Microsoft, SQL, 2005, SQL2005

Posted on 2008-10-23
4
262 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
A short film showing how OnPage and Connectwise integration works.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

948 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now