send sms to a mobile phone from sql server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » send sms to a mobile phone from sql server...

send sms to a mobile phone from sql server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

abdou.amara

Posted Thursday, December 27, 2012 5:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 27, 2012 11:32 AM
Points: 3, Visits: 3

hey everybody ! please can someone tell me if we send sms to a mobile phone from SQL SERVER 2008

if yes tell me how to do it !! plzz i really need it

thanks

Post #1400566

Joel Ewald

Posted Thursday, December 27, 2012 6:13 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 7:02 AM
Points: 1,570, Visits: 990

You may want to look at
http://stackoverflow.com/questions/2047536/sending-an-sms-through-sql-server-2008

Post #1400589

zulmanclock

Posted Thursday, December 27, 2012 10:34 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 11:22 AM
Points: 207, Visits: 220

Tested and works,You could use the SP_SEND_DBMAIL option. For this you need to specify some paramaters as seen below, for the @recipients you could just enter the correct text message address something like 1234567890@vtext.com(for verizon wireless) and receive the message.

sp_send_dbmail [ [ @profile_name = ] 'profile_name' ]
[ , [ @recipients = ] 'recipients [ ; ...n ]' ]
[ , [ @copy_recipients = ] 'copy_recipient [ ; ...n ]' ]
[ , [ @blind_copy_recipients = ] 'blind_copy_recipient [ ; ...n ]' ]
[ , [ @subject = ] 'subject' ]
[ , [ @body = ] 'body' ]
[ , [ @body_format = ] 'body_format' ]
[ , [ @importance = ] 'importance' ]
[ , [ @sensitivity = ] 'sensitivity' ]
[ , [ @file_attachments = ] 'attachment [ ; ...n ]' ]
[ , [ @query = ] 'query' ]
[ , [ @execute_query_database = ] 'execute_query_database' ]
[ , [ @attach_query_result_as_file = ] attach_query_result_as_file ]
[ , [ @query_attachment_filename = ] query_attachment_filename ]
[ , [ @query_result_header = ] query_result_header ]
[ , [ @query_result_width = ] query_result_width ]
[ , [ @query_result_separator = ] 'query_result_separator' ]
[ , [ @exclude_query_output = ] exclude_query_output ]
[ , [ @append_query_error = ] append_query_error ]
[ , [ @query_no_truncate = ] query_no_truncate ]
[ , [ @mailitem_id = ] mailitem_id ] [ OUTPUT ]

Post #1400703

jerker.dahlblom

Posted Sunday, December 30, 2012 3:24 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 04, 2013 2:13 AM
Points: 16, Visits: 61

You can use the dSMS for sending SMS using a GSM modem. Pm me if you want more information. dSMS is cheap and reliable. Offers a lot of automation functionality too.

Post #1401242

« Prev Topic | Next Topic »

Permissions