Hi everyone

I am very very curious to find out how we could automatically notify the admin or users, or change the UI automatically if a record is added/removed/changed/... in SQL 2005 or 08

I am sure it is a very common task for many different scenarios.

Thank you

Currently dealing with similar myself.

one of the way is using triggers. which will fire in the case of insert,update or delete on that table. in that trigger code, write an Email send code which will sent the email to the users.

to send email to the users from sql server,

http://forums.asp.net/t/981809.aspx

 or you can use windows service which will runs automatically, in that windows service, write a stored procedure which will check the changes in records and sent the email to the users. here you can send email from the front end.

 This is what I want to do.

lets say someone upload a new file to my server. now I want to send that file to someone else automatically, without my human intervention. is it possible to do this using WCF ?

Thank you.

Rahabm:

 This is what I want to do.

lets say someone upload a new file to my server. now I want to send that file to someone else automatically, without my human intervention. is it possible to do this using WCF ?

Thank you.

 You can do this code side by simply ON UPLOAD Success, Call WCF code to send email to the appropriate person