Message from SQL Server database to application when something changes in database

I have used triggers within a database .. like .. when record in table A is deleted then also delete the corresponding record in table B, C D .. e.c.t

In SQL Server, is there a way to send message to application from database using triggers ...

The scenario is ...

If same application ( .exe ) is opened by 2 users and both use the same database ... then is 1st user 开发者_高级运维has deleted an item ... then 2nd user should see it immediately ... or something like that.

You can use Query Notifications. See: MS Sql 2008 Query Notifications MS Sql 2005 Using Query Notifications With C#