Sending SMS through Stored Procedures???

Question

Sending SMS through Stored Procedures???

nraaj.del

Old Hand

Points: 346
More actions
March 16, 2010 at 1:38 am

#230874

How could we send SMS through Stored Procedures in MS-SQL Server 2005. Please share your concern about this.
Thanx
Navneet.
September 2, 2022 at 12:18 pm

This was removed by the editor as SPAM
February 28, 2023 at 11:35 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

Skull Killer SSCrazy Points: 2504 More actions · Answer 1

If you can send a sms from .Net (you have to aquire a service that does that or you could use a mobile phone (or other electronic device that send sms) you can add an assembly with that functionality.

nraaj.del Old Hand Points: 346 More actions · Answer 2

i want to send SMS through Stored procedure in SQL-Server 2005. so that i schedule it to run after a time span.

Skull Killer SSCrazy Points: 2504 More actions · Answer 3

You can do that with an assembly.

A webservice to do that: www.aspsms.com[/url] (I haven't tried it out). You can call that webservice from sql server with an assembly in .Net.

An article about calling webservices from Sql Server at Database Journal.

Hope that helps.

Paul White SSC Guru Points: 150468 More actions · Answer 4

Store the data describing the message you want to send to a queue table.

Write a separate application to read from that table and send the messages.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

nraaj.del Old Hand Points: 346 More actions · Answer 5

@SSCarpal Tunnel,

Allright, but i want seperate application would be stored procedure, so could i send SMS through Stored procedure.

Paul White SSC Guru Points: 150468 More actions · Answer 6

nraaj.del (3/16/2010)
@SSCarpal Tunnel,
Allright, but i want seperate application would be stored procedure, so could i send SMS through Stored procedure.

My name is Paul 😛

The stored procedure should just write to the queue table.

The external application should manage the process from there, also via stored procedures.

If the requirement justifies a more scalable solution, consider using Service Broker.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

LutzM SSC Guru Points: 107049 More actions · Answer 7

Did you try to google for a solution?

I just tried "sql server sms" as key words and found several solutions.

One is

http://www.siccolo.com/Articles/SQLScripts/how-to-create-trigger-to-sms-email.html

But there are a lot more....

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

Not to "plug" a certain provider but ClickATell (www.clickatell.com) offers an SMTP to SMS bridge which I have actually used successfully. It aint free but it works well.. You could probably use Database Mail to do it.

CEWII

crazy4sql SSCoach Points: 19590 More actions · Answer 9

so far we can configure in sql server to send the alert in mail. Configure the mail in your mobile and problem solved...

----------
Ashish

Paul White SSC Guru Points: 150468 More actions · Answer 10

ashish.kuriyal (3/19/2010)
so far we can configure in sql server to send the alert in mail. Configure the mail in your mobile and problem solved...

I think the OP wanted an SMS solution specifically.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi