SQL Server mail won't alert my phone by text message

[Skkra]

I'm trying to set up a system of alerts in SQL Server 2008 R2. Using Database Mail to email me works fine. However, I also want to receive a text message - I get dozens of after-hours emails a day, and if my phone buzzed for every one, I'd go insane. A text message will get my attention.

I have a Verizon iphone and can't seem to send myself texts through SQL Server. Querying the failed mail table (select * from msdb.dbo.sysmai l_faileditems) shows a plethora of failed messages to my phone. I've tried my number @vzwpix.com and @vtext.com. Both of those addresses work fine when using gmail or outlook to send messages, but SQL Server's database mail wont send to either.

Has anyone else run into this in the past? I'm spinning my wheels but going nowhere right now.

[ck9663]

I think you need an SMS server or at least an interface for that. I tried sending email as text and it used to work for me. Those were the days of not so smart phones so telcos are allowing it. I have not tried it again, though

~~ CK

[Skkra]

The problem ended up being on the Exchange side of things. Thanks for your response though!