Solved

Microsoft, SQL, 2005, SQL2005

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to enforce inte 8 51
MS SQL 2005 Srink database in chunks 4 57
MS SQL page split per second is high 19 92
Impove long SQL Stored Procedure Performance 14 73
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 …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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

8 Experts available now in Live!

Get 1:1 Help Now