Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 data update notification

Author  Topic 

peace
Constraint Violating Yak Guru

420 Posts

Posted - 2012-06-28 : 23:10:51
how can i check if the data is updated, send notification to email?
can i do that?
any straight forward query?

Name House
Jane blue
Jason red
Juth pink

If Jane updated to red house, notification will be send to my mailbox.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-06-29 : 05:08:51
something like this?
http://ask.sqlservercentral.com/questions/41683/trigger-based-on-a-column-value-change-and-email-n.html


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -