Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Toast

I have been working as a SQL Administrator for more than 5 years and it has been an enriching and exciting experience. I want to contribute back to the community which has given me a lot over the years.

Send SMS from SQL Server

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production server. Though this is NOT a feature of SQL Server, but we have a simple workaround for this.

Cell phone service providers have a SMS gateway. These gateways accept requests via email.
To send sms to any mobile number we need to send email to this gateway. I have IDEA connection and was successfully able to receive sms on my cell by sending mail to below gateway :

MyCellNumber@ideacellular.net

You can quickly check by sending mail to this from your gmail account.

There is a list of gateways I found on below link :

http://basicstate.com/htm/page.htm


Filed under: SQL Server, Uncategorized

Comments

Leave a comment on the original post [harshdba.wordpress.com, opens in a new window]

Loading comments...