Difficulties to use sp_send_dbmail with @@SERVERNAME

• vincent.D_FR

  Mr or Mrs. 500

  Points: 522

  More actions

  February 4, 2014 at 3:09 am

  #148420

  Hi everyone,

  I have some trouble with the sp_send_dbmail procedure.

  I use the following code :

  declare @Body varchar(500)

  set @body = 'my text for server ' + @@servername

  exec msdb..sp_send_dbmail

  @subject = 'my_subject' ,

  @recipients = 'my_email_adresse',

  @query = @Body ,

  @profile_name = 'my_profile'

  But I have the following error :

  Msg 22050, Level 16, State 1, Line 0

  Error formatting query, probably invalid parameters

  Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 504

  Query execution failed: Msg 156, Level 15, State 1, Server [SERVERNAME], Line 1

  Incorrect syntax near the keyword 'for'.

  Do you know what I do wrong ?!

  Thanks in advance !

• KS

  Hall of Fame

  Points: 3323

  More actions

  February 13, 2014 at 4:58 am

  #1688671

  DECLARE @MailBody VARCHAR(500)

  SELECT @MailBody = 'My text for server ' + @@SERVERNAME

  EXEC MSDB..SP_Send_DBMail

  @Subject = 'my_subject',

  @Recipients = 'my_email_adresse',

  @Body = @MailBody,

  @Profile_name = 'my_profile'

• vincent.D_FR

  Mr or Mrs. 500

  Points: 522

  More actions

  February 14, 2014 at 8:33 am

  #1689103

  many thanks 🙂