Home Forums SQL Server 2005 T-SQL (SS2K5) Difficulties to use sp_send_dbmail with @@SERVERNAME RE: Difficulties to use sp_send_dbmail with @@SERVERNAME

  • 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'