sp_send_dbmail in text-format

• prothmann

  SSC Enthusiast

  Points: 124

  More actions

  January 25, 2010 at 6:48 am

  #386173

  Hello

  I'm upgrading from SQL Server 2000 to SQL 2008.

  A lot of Jobs where using an third-party Software called 'SendSAM' for sending Emails with SQL Server. On the new SQL Server I returned to the System Procedure 'sp_send_dbmail' which works fine....

  Now, when I want to send an Email in Text-Format (not HTML) the whole Email is in a bad Format because the character Set which is used to send the Email is not in Unicode (it uses ARIAL)

  So, where can I change the Format of the Text-Character-Set SQL Server is using?

  Thanx in advance....

  Severin

• prothmann

  SSC Enthusiast

  Points: 124

  More actions

  January 25, 2010 at 8:58 am

  #1108201

  hello all

  found the answer by myself...

  there are no settings in SQL Server which can help to configure the text-format of a text-formatted-email.

  SQL Server is taking allready Unicode-characters.

  The only thing is, that email-clients like outlook or so will convert the characters to i.ex. Arial. Which is no Unicode-Set.

  thanks anyway.

  severin