SQL 2005/2008 Database Mail and Reciepients with two periods to the right of the @

• Buzz-523717

  Mr or Mrs. 500

  Points: 544

  More actions

  February 23, 2011 at 10:56 am

  #97651

  I have a job that processes notifications table entries to send alterts and notifications.

  I am having an issue with Database mail chopping the address if there is more than one period associated with the domain in the email address.

  A good example is sending mail a cellular device utilizing the SMTP address.

  e.g. 55512341212@messaging.sprintpcs.com

  I found that the intended recipients were not receiving these.

  I CC'd myself to see the address reflected as 55512341212@messaging.sprintpcs

  I then checked msdb.dbo.sysmail_mailitems and see that the address is 55512341212@messaging.sprintpcs

  Is there any configuration setting or work-around to cause Database mail to handle the multiple domain listing?

  Any help anyone can provide is greatly appreciated.

  Thank you.

• Buzz-523717

  Mr or Mrs. 500

  Points: 544

  More actions

  February 24, 2011 at 10:46 am

  #1291126

  Resolved- problem was between my keyboard and chair.

  The 30 characters should have been a clue.

  I had defined my variable for the SMS/SMTP address as VARCHAR(30) but the DB Storage was 100. Thus, I was truncating the address myself.

  It's been a busy week.

  Most humbled.