|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, August 16, 2010 7:06 AM
Points: 1,
Visits: 6
|
|
| pls help me with how to use sql server 2000, or2005,2008 to send sms to mobile number if transaction is made on the database
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 2:29 PM
Points: 11,645,
Visits: 27,733
|
|
eni11_g (8/16/2010) 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 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:
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.com T-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
Lowell
--There is no spoon, and there's no default ORDER BY in sql server either. Actually, Common Sense is so rare, it should be considered a Superpower. --my son
|
|
|
|