I used "SMS", "SMS Text" keyword searches but did not come up with any results. Are the hosted SQL2008 db's configured to send email? That is, will my StoredProcedures that implement emailing work? Can an SMS Gateway (like OZEKI NG SMS Gateway) be used? Or Clickatell? Thanks!
After a bit of google-foo work I found this archive post: http://forum.Winhost.com/archive/index.php/t-3504.html "Ray08-12-2010, 08:39 AM No, no, you can run stored procedures to run select,insert or update data, but some stored procedure call on the CLR which we do not support. Plus some customers want to setup the store procedures to run under the schedule job function within SQL, that too we do not support. And some store procedures are coded to send email through the SQL servers SMTP service. We have disabled the SQL servers SMTP service." This is a complete and total bummer. Anyone from Winhost: is there any possibility of changing this policy?
Afraid not. We do not want outgoing mail originating from our SQL servers. We can't monitor that kind of sending the way we can monitor our email gateways.
