Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SMS TO MOBILE Expand / Collapse
Author
Message
Posted Monday, August 16, 2010 6:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Post #969713
Posted Monday, August 16, 2010 6:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:24 PM
Points: 12,881, Visits: 31,816
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
Post #969724
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse