You can do this with a trriger and 2 tables.
CREATE TABLE Event(id INT INDENTITY(0,1), EventTxt VARCHAR(8000))
CREATE TABLE Viewed (IdUser INT, IdEvent INT, Viewed BIT DEFAULT (0) )
CREATE TRIGGER triger_name
ON your_table FOR UPDATE AS
IF
(
(UPDATE(your_field))or
)
BEGIN
INSERT INTO Event (EventTxt) VALUES ('Filed was update')
INSERT INTO
END
After you do this you will use a watch component to see.
Want new events are in table with this procedure
PROCEDURE CREATE new_events
@UserId
AS
SELECT e.Id,e.EventTxt FROM
Event e join Viewed w on e.Id=w.IdEvent WHERE Viewed=0
Now when app show message with event you will
UPDATE Viewed SET Viewed=1 WHERE IdEvent= event id AND IdUser= loged user
Submit an article or tip