SMS alert through Sql Server 2008


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
more ▼

asked Apr 20, 2011 at 03:53 AM in Default

Mohan Kumar gravatar image

Mohan Kumar
204 18 20 21

(comments are locked)
10|1200 characters needed characters left

3 answers: sort oldest

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

answered Apr 20, 2011 at 03:59 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.8k 47 49 76

Thanks a lot...
Apr 20, 2011 at 04:04 AM Mohan Kumar
(comments are locked)
10|1200 characters needed characters left

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/
more ▼

answered Apr 20, 2011 at 04:00 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

Thanks a lot.
Apr 20, 2011 at 04:03 AM Mohan Kumar
(comments are locked)
10|1200 characters needed characters left
Where I worked before we just used the email to SMS feature of the phone system. It worked fine.
more ▼

answered Apr 20, 2011 at 04:02 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

Thanks.. I understand the email notification. Could you please explain how you sent SMS?

Apr 20, 2011 at 04:10 AM Mohan Kumar
Verizon could receive email that went to SMS.
Apr 20, 2011 at 04:16 AM Grant Fritchey ♦♦
Thanks again.
Apr 20, 2011 at 05:00 AM Mohan Kumar
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 20, 2011 at 03:53 AM

Seen: 2366 times

Last Updated: Apr 20, 2011 at 04:19 AM