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.
Author |
Topic |
haekz008
Starting Member
10 Posts |
Posted - 2012-01-16 : 22:21:18
|
who has an idea on how am i going to create a codes that automatically checks the database if theres an update,for example: a new user was added in the database,,my problem is,.how i will create a notification that will tell the other user that theres a new user added?help me please,.,thankyouhaekz008 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-16 : 22:25:19
|
seems like what you're looking at is an insert trigger on user tablehow do you want to implement notification part? do you want to send out mail?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-17 : 01:42:09
|
An alternative to triggering an email every time a user is added , you could run a query at regular intervals and create a reportJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
haekz008
Starting Member
10 Posts |
Posted - 2012-01-17 : 03:10:42
|
thanks for the suggestions., i want to make it just like what facebook have. if the comment was posted, a notification will appear to the account of the person that youve comented.haekz008 |
|
|
|
|
|