The place I work we use the triggers in MSSQL to notify other users of changes that take place. In MSSQL I created a table named HotList. This table holds a userid, short description, notes field and a few other misc. fields. When we have a problem with an item and it falls into the criteria for the trigger, an item is added to the users HotList. This lets the user know what’s wrong and when it happened.

Pit fall, you have to write a HotList form for the application and do not allow the users to close it. Then set a refresh timer on the form to update the data in the grid.

Not sure if that helps you or not, but it’s the way we handle it.