SQL Server Performance

xp_sendmail issue

Discussion in 'SQL Server 2005 General DBA Questions' started by jogin malathi, Nov 11, 2008.

  1. jogin malathi New Member

    xp_sendmail: Procedure expects parameter @user, which was not supplied.
    Iam using following scriptEXEC
    master..xp_sendmail @recipients = xxx@xxx.in', @subject = 'Email Notification', @message = 'Hi..This is Test Mail'
    Is that iam missing something here..?
  2. Adriaan New Member

    Quite obviously your call does not mention the @user parameter, which is required.
  3. jogin malathi New Member

    xp_sendmail { [ @recipients= ] 'recipients [ ;...n ]' } [ ,[ @message= ] 'message' ] [ ,[ @query= ] 'query' ] [ ,[ @attachments= ] 'attachments [ ;...n ]' ] [ ,[ @copy_recipients= ] 'copy_recipients [ ;...n ]' [ ,[ @blind_copy_recipients= ] 'blind_copy_recipients [ ;...n ]' [ ,[ @subject= ] 'subject' ] [ ,[ @type= ] 'type' ] [ ,[ @attach_results= ] 'attach_value' ] [ ,[ @no_output= ] 'output_value' ] [ ,[ @no_header= ] 'header_value' ] [ ,[ @width= ] width ] [ ,[ @separator= ] 'separator' ] [ ,[ @echo_error= ] 'echo_value' ] [ ,[ @set_user= ] 'user' ] [ ,[ @dbuse= ] 'database' ]
    I see this pocs has above parameters.I don't find @user as parameters out of these.

Share This Page