September 9, 2002 at 2:32 am
Hello
I would like to know if is possible to send to a mobile phone an SMS message and if SQL SERVER have any stored procedure to do that, or, if someone make this ??
Thanks
September 9, 2002 at 6:12 am
All you can do from SQL is send email using xp_sendmail. Beyond that you could just pull the data using a query via an external app and format it however you need.
Andy
September 9, 2002 at 12:07 pm
Another consideration is ActiveX scripting. If you can do it using VBScript, JScript or some other scripting language installed on the system (like PerlScript), you can extend SQL Server via such a means. Or if you are really brave, I'm sure someone could write an extended stored procedure.
However, as Andy has indicated, most paging devices now have an email address. SQL Server can send specially formatted messages to a paging address which are less verbose than the ones it would send to a normal email address. However, this is only through SQL Server agent and it leverages SQL Mail, just as you would through xp_sendmail. The catch is SQL Server strips down the amount of text it sends based on some choices you make.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply