InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:50:02 GMT20http://www.sqlservercentral.com/Forums/Topic969713-391-1.aspx[quote][b]eni11_g (8/16/2010)[/b][hr]pls help me with how to use sql server 2000, or 2005,2008 to send sms to mobile number if transaction is made on the database[/quote]every carrier has support for sending an email to their 10 digit phone number, and it appears to the end user as an SMS text message...the problem is you need to know the cell number's carrier in order to do it;probably not a problem if you are texting people from within your organization; here's some examples for reference:[code="plain"]you can try to use www.data24-7.com to find out which carrier a number is:AT&T – cellnumber@txt.att.net Verizon – cellnumber@vtext.com or phonenumber@vzwpix.comT-Mobile – cellnumber@tmomail.net Sprint PCS - cellnumber@messaging.sprintpcs.com Virgin Mobile – cellnumber@vmobl.com US Cellular – cellnumber@email.uscc.net Nextel - cellnumber@messaging.nextel.com Boost - cellnumber@myboostmobile.com Alltel – cellnumber@message.alltel.com Cincinnati Bell Wireless it’s cellnumber@gocbw.com--eleven digit!Metro Pcs 14352345762@mymetropcs.com[/code]Mon, 16 Aug 2010 06:41:28 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic969713-391-1.aspxpls help me with how to use sql server 2000, or2005,2008 to send sms to mobile number if transaction is made on the databaseMon, 16 Aug 2010 06:25:15 GMTeni11_g