Send SMS From MS SQL Server after data is inserted or updated into table.

Question

Currently i'm working on Core banking project, it use ASP.Net  with C# as front-end and MS SQL Server as Back-end. actually i am facing a problem in project that i want to send SMS to the customer when they will do any kind of transaction like Credit/Debit.

in this project when customer do any kind of transcation it is not inserted into table untill officer is not confirm the records, onces the officer is confirm individal transcation or bunch of transcation after that sms send to the bank Customer.

i getting confuse how to send SMS From MS Sql Server 2008 to mobile phone, pl help me to do this either using Store procedure or Triggers Waiting for reply.

Answer 1

We also send sms alerts to customers for their bills.

what we do

1. insert all the data with mobile_no into a table to whom you want to send sms.

2. we will email all the mobile nos to one third party mail address who transmit them to customers

  emailids: [e-mail],[e-mail]....

you can add a columns 'status' and 'mobileno' to the table to which you adds data of customer.

is status = 'new' then do nothing

   status = 'confirm' then send the mobile no to the sms provider from where you can send sms and change status = 'sent'

   status = 'sent' then do nothing