I'm using send_dbmail to send a text message to customers. This is the following sql:

exec msdb.dbo.sp_send_dbmail
@recipients='[email protected]',
@body='check out this url https://www.someurl.com/directory/blah.aspx',
@subject='I am the subject!'

The body gets truncated to "check out this url https://www.someurl.com/directory/blah.as" (the "px" is removed from the end of the url).

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.

Any ideas?

Thanks.