Email using msdb..sp_send_dbmail

  • Hello,

     

    I have a data export process using msdb..sp_send_dbmail.  Most fields come out to the CSV export "clean" expect for a Notes field which is because of the various characters that seem to impact the @Query_Result_Separator.  Is there a common recommendation as to how to solve this problem?

    My query looks like this:

    SET @QRY2 = 'SET NOCOUNT ON;SELECT ID, Notes FROM my Table'

     

     

    • This topic was modified 1 year, 2 months ago by  rjjh78.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

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