I have 12 SQL 2014 instances in 3 different domains (dev, test, stage).
Each SQL instance has 3 distinct email profiles and each domain has its own mail server.
I tested different queries on each instance, all truncate the result set when attaching the query.
Time to open a call with MS.
Thank you.
Francis S. Mazeika
MS SQL DBA
609-707-5207
francis.mazeika@gmail.com