Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: sp_send_dbmail to SMS error

    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...

  • RE: sp_send_dbmail to SMS error

    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...

  • RE: sp_send_dbmail to SMS error

    Just sent you a private message.

    Cheers

  • RE: sp_send_dbmail to SMS error

    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...

  • RE: sp_send_dbmail to SMS error

    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...

  • RE: sp_send_dbmail to SMS error

    Get the same thing sms says:

    dGVzdA==

  • RE: sp_send_dbmail to SMS error

    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',

    ...

Viewing 7 posts - 1 through 7 (of 7 total)