HOw to send SMS Using t-sql

Question

HOw to send SMS Using t-sql

SQL Dev-938873

Ten Centuries

Points: 1280
More actions
July 20, 2009 at 6:56 am

#140009

Hi,
How to send using T-SQL ( ofcourse using GSM port integration ,but how to intigrate )
Any suggestions..
Thanks in advance,....
GaNeSH
February 6, 2017 at 3:43 am

This was removed by the editor as SPAM
February 6, 2017 at 3:48 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Are you sure you want to use a local GSM gateway? If not, there are providers like ClickATell who provide several different interfaces. I like them and have used them before. Also there is no direct way to do this from SQL. With that said you could write a SQLCLR object to send them. There is a project on CodePlex called SMS Task, it might provide some code to make a SQL CLR object. It is at:

http://smstask.codeplex.com/

If you are still intent on a GSM solution there is a company, which unfortunately I can't remember their name, that have a solution that is backed by SQL Server. But it is pricey..

CEWII

Lowell SSC Guru Points: 323518 More actions · Answer 2

there's a script in the scripts ection for sending an SMS in a trigger here:http://www.sqlservercentral.com/scripts/Miscellaneous/31899/[/url]

that uses the exisitng email-to-SMS functions that every cell carrier seems to support.

there's a lot of other examples if you search for "SMS" here on SSC.

did you mean the actual modem connection and everything, or is that sufficient? there's another thread that has the actual modem handling on codeproject.com, but I'm not sure what you need.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

The company that makes the SMS Gateway I was talking about is Ozeki NG.. It is at:

http://www.ozekisms.com/

CEWII

Steve Jones - SSC Editor SSC Guru Points: 736150 More actions · Answer 4

That gateway supports email, so sp_sendmail should work.

Don't do this from a trigger. Let the trigger drop data in a table and then use a job that checks the table every minute and sends the email.

ps. One Orange Chip Points: 29422 More actions · Answer 5

In my previous organization, i'd written a sms gateway in vb 6.0 that was using a third party tool (air2web) to send SMS. The gateway had schedulers running which brought relevant details from various sources(oracle, sql server, excel files) at regular intervals defined in a 'Rules' table to an smsFetch table and a timer used to run which used to read and parse data from this smsFetch table and used to send the sms. The vendor had given us a URL with which contained userid/pin, mobileno and smstext as parameters of the URL and the timer used to invoke for each row of data.... Charges were INR 0.18 per sms for national sms and Rs 3 for international sms.

There are other vendors who provide dll's which you can incorporate (if you're planning to write a short program for it).

Pradeep Singh

mnatives Valued Member Points: 72 More actions · Answer 6

Hi

i Think

SMS gateway is highly robust, scalable with the capacity of handling a peak load of 1500 SMS per second.

Bulk SMS Gateway
Click here offers