android notification from webapplication using sql server

I want to send notification  everytime to android device when sql sever gets modify. i don't know how to do it ?  i want to know technique for this..
AKSHAY SHEGDEAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
lcohanDatabase AnalystCommented:
An android device is usually tied to an email and you could configure SQL mail as described in detail here https://www.codeproject.com/tips/846204/how-to-send-mail-using-sql-server-part and send the notification via email.
Depending what you mean by  "when sql sever gets modify" is how you "trigger" that email as you can send it directly via/from a trigger however - CAUTION with that as it may cause various issues depending on how many  data changes the table(s) take. You can also send the email from the piece of code that modifies data directly but again it all depends on the volume of changes and implicit the number of email notifications to be sent.
0
All Courses

From novice to tech pro — start learning today.