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