Post reply

xp_sendmail error...

  • November 16, 2006 at 11:37 am

    #193170

    All,

    I am getting the following error

    I try to execute:

    EXEC master.dbo.xp_sendmail @recipients = '<my email>', @message=N'Test'

    I get:

    Msg 17985, Level 16, State 1, Line 0

    xp_sendmail: Procedure expects parameter @user, which was not supplied.

    But this is not a parameter in BOL.  Any ideas???

    Thanks, Ben

  • November 16, 2006 at 12:35 pm

    #672416

    Is it safe to say that this is the format of your exec:

    exec master.dbo.xp_sendmail @recipients = N'username@company.com', @message = N'Test'

    If so, I have no idea as this works for me.

  • November 17, 2006 at 8:28 am

    #672634

    Curious, are there any known issues with xp_sendmail from just having the SQL Server Standard Edition as opposed to SQL Server Enterprise Edition?

    I am getting a different error today:

    Msg 17930, Level 16, State 1, Line 0

    xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.

     

     

  • November 20, 2006 at 5:36 am

    #672907

    you should use dbmail in SQL2005.

  • November 20, 2006 at 6:56 am

    #672915

    Yes, I set that up last week and it is working fine now, thanks!  A word to the wise however; when you are setting up a profile configuration, don't place any spaces in the Display Name or the account will not work.  After I remedied this, sp_send_dbmail began working fine.

    Thanks again,

    Ben 

  • November 20, 2006 at 12:42 pm

    #673039

    All,

    Now that I have the sp_send_dbmail working, I have tried to incorporate that into a trigger for confirmation info.  I've tested the process in Query Analyzer and it works fine.  When I try to apply the trigger, the app gives the users a "Page Cannot be Displayed" error.  Any ideas?

    Thanks!

  • December 6, 2007 at 1:51 pm

    #757855

    Answer here:

    1.0-I did Install OUTLOOK 2003 SP2 (Win 2003 SP2, SQL 2005 SP2)

    Note: I was getting this error using OUTLOOK 2000 SP1

    1.2- Setup outlook using EXCHANGE...then send test e-mail using outlook...

    2-Rename MAPI Profile name to SQLMail (Do Not use the default)in control panel "mail" Also delete the original profile

    3-Enable SQL Mail in SAC (Service Arae Configuration)

    4-Reboot SQL server

    5-Configure SQL Server Agent to Enable mail profile using Using SQLMail and select the profile name (Step2)

    6-In Management Studio/Legacy Right Clic on SQL MAIL properties then select the MAPI profile name (Step2)

    7-Run master.dbo.xp_sendmail 'me@sql.com', 'Test from MAPI'

    Good luck!:)

  • September 9, 2011 at 9:19 pm

    #1379558

    you shouls take the @user variable

    and then pass the variable name into it

  • September 9, 2011 at 9:19 pm

    #1379559

    you shouls take the @user variable

    and then pass the variable name into it

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply