0
since most mobile phone providers use SMS that can be sent to a specific email address, you can use System.Web.Mail, and use Google's SMTP server as your SMTP server. all free and ready to use and no need to use SQL Server.
for example, to send a SMS message to a Verizon phone, the email address is [10-digit number]@vtext.com
however, you will need a GMail account and the SMS message will come from that account, so that's probably not what you want.
0
You can refer the following article.
1.http://www.codeproject.com/KB/database/SMS_message_from_SQL.aspx?display=Print