question

Mohan Kumar avatar image
Mohan Kumar asked

SMS alert through Sql Server 2008

Hi We need SMS alert through our Web application (DB : Sql Server 2008). When a user clicks any advertisement, a SMS has to be sent to the person who has posted the advertisement. I googled, but could not come to any conclusion. It looks like we have to integrate link to some other solution provider. But I'm not sure. Kindly let me know how this can be achieved. Rgds Mohan Kumar VS
sql-server-2008alertsnotificationsms
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
Yes you would have to utilise some 3rd party software/service to generate the SMS. Generally these work by sending a pre-formatted email to a service, and it then generates the SMS message. People often think of SMS as 'just like' email, but the reality is that you probably have access to an Exchange server on your network, or even in the cloud, that enables this functionality for you, but do you have a 'SMS server' (or whatever the technological term is)? No, probably not, so you have to tap into one.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks a lot...
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered
Well, this really has nothing to do with SQL Server. But, in your web application, when you handle the click, then use whatever code your SMS provider gives you to send the SMS. Most providers have some sort of API, or others have email to SMS translation. At the day job we use [eSendex][1] which does both. [1]: http://www.esendex.co.uk/
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks a lot.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Where I worked before we just used the email to SMS feature of the phone system. It worked fine.
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks.. I understand the email notification. Could you please explain how you sent SMS? Rgds
0 Likes 0 ·
Verizon could receive email that went to SMS.
0 Likes 0 ·
Thanks again.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.