December 27, 2012 at 5:10 am
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
December 27, 2012 at 6:13 am
You may want to look at
http://stackoverflow.com/questions/2047536/sending-an-sms-through-sql-server-2008
December 27, 2012 at 10:34 am
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 ]
December 30, 2012 at 3:24 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply