I am trying to email a csv using sp_send_dbmail but one of the column values are truncating at 255 characters. So I used the @query_no_truncate parameter to display the full column value in the csv file, it works but omitted the column header.
Is there a way to keep both column header and full column value in the csv file, please?
I tried query_no_truncate parameter