I have tried personally triggers inside a database .. like .. when record in table A is erased then also remove the related record in table B, C D .. e.c.t

In SQL Server, it is possible to method to send message to application from database using triggers ...

The scenario is ...

If same application ( .exe ) is opened up by 2 customers and both make use of the same database ... then is first user has erased a product ... then second user should view it immediately ... or something like that like this.