Symptoms
Running xp_sendmail can cause SQLMail to get an exception error and stop ifall of the following conditions are true:
One of the rows returns more that 2,000 bytes.The @width parameter is set greater than 2,000The results are not attached as a file.
Resolution
To work around this problem, do either of the following:
Use the parameter @attach_results=true.
-or-Do not set @width greater than 2000.