We actually upgraded to SQL2008 and it's not a problem having kept the same phone provider. I checked against some of our SQL2005 boxes and they are fine also. I...

Didn't manage to get this resolved. In the end as it was a small number of sms to be sent I created an outlook rule to forward to my mobile...

Just sent you a private message.

Cheers

would anyone be able to use the free trial at the address below to see if they get the same error. At least it may clear up if it is...

Just tried your script and get the same, only difference is the provider

EXEC msdb.dbo.sp_send_dbmail

--@profile_name = 'Default',

@recipients = 'mobileno@esendex.net',

@body...

Get the same thing sms says:

dGVzdA==

Cheers for the response. Have tried it using 'Test' as the text body see below:

DECLARE @ServerName varchar (100)

declare @body1 nvarchar(100)

SET @ServerName = @@servername

set @body1 = N'test'

EXEC msdb.dbo.sp_send_dbmail @recipients = 'mobileno',

...