Sending SMS through SQL Server 2008

Question

Is there a way to send SMS through SQL Server 2008?

Answer 1

No, this is not a feature of SQL Server.

Answer 2

One option is to use an SMS gateway, such as the Clickatell API .

The Clickatell API offers a choice of connection options, including the SMTP method, which you can use by sending a text message from SQL Server to [e-mail] with the following body:

 user: your_api_username password: your_api_password api_id: your_api_id to: sms_number text: sms_body 

To send email with SQL Server 2008, you can check out the following article:

• Configure database mailbox - send email from an SQL database .

Another option is to write a CLR stored procedure that communicates with the SMS gateway through any protocol supported by the gateway.

Answer 3

Each mobile operator has an email address that will be sent to the SMS / text of their subscribers, and you simply send an email to these addresses, and the recipient will receive messages via sms.

Example. [e-mail]

This is a page link for most carrier emails in text format. Please note that this may not contain the latest information.

The best way is to contact technical support for your operator, get information and test this feature by sending an email and see if you receive sms /

Answer 4

Yes, although not initially. You will have to use the SMS gateway service and run some programs around it. They come in several formats, sometimes free, but usually with some form of payment per message.

Standard gateways will accept message requests via email, webmail, or a full web service. Depending on the gateway service, it may offer one, several or all of these parameters.

Back in the "old days" when I started receiving mobile SMS, in the UK, at least, you could also use a dial-up modem to dial a specific network number and enter an SMS message. If this is still available in the area you are looking for, then the advantage of this is not setting up an account, since it is charged to your phone bill.

Answer 5

I found an article that uses a C # application with SQL Server Backend to send SMS messages. Not exactly what yours, but may give you another option.

SMS messages from SQL

Answer 6

How about an option that allows you to do this in a single line of code.

twiSQL - allows you to send text messages and make phone calls from SQL server

austinHenderson.com - author site

Answer 7

An easy way would be to write a CLR procedure that sends sms via http to the SMS gateway of your choice.