x

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

more ▼

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

avatar image

Mohan Kumar
204 19 20 24

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

3 answers: sort voted first

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

avatar image

Kev Riley ♦♦
66.1k 48 63 81

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 which does both.

more ▼

answered Apr 20, 2011 at 04:00 AM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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

avatar image

Grant Fritchey ♦♦
137k 20 44 81

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

Rgds

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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x2188
x14
x8
x2

asked: Apr 20, 2011 at 03:53 AM

Seen: 2617 times

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

Copyright 2017 Redgate Software. Privacy Policy