title: Trying to send text message using sp_send_dbmail truncates url in body
body: <p>I'm using send_dbmail to send a text message to customers.  This is the following sql:</p>
  
  <pre><code>exec msdb.dbo.sp_send_dbmail
  @recipients='5558881234@txt.att.net',
  @body='check out this url https://www.someurl.com/directory/blah.aspx',
  @subject='I am the subject!'
  </code></pre>
  
  <p>The body gets truncated to "check out this url <a href="https://www.someurl.com/directory/blah.as" rel="nofollow">https://www.someurl.com/directory/blah.as</a>"  (the "px" is removed from the end of the url).</p>
  
  <p>I've ruled out message length as I have tried sending just "www.google.com/test.aspx" and the "px" is removed as well.   Another strange thing, when I try forwarding the text message to myself and add the "px" back on myself, it works.  It also works if I send a email from outlook with the same body.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks.</p>