CallBack for autoupdate table

[maciejw]

Is possible to use any callbacks which allow implementation of autoupdate table and query using sdac and MsSQLServer 2003/2005 ?

[Ikar]

What do you mean on "autoupdate"? On execution Post UPDATE statement is generated automatically.

[[email protected]]

1. Imagine yourself a following situation.... The same database table is displayed on few computers connected to the same sql server.

2. One of them make any kind of record modification (delete, edit or append).

3. Goal of problem is to update data displaying on others host immediately after its modified by one of them.

I have this problem resolved using additional communication basic on tcp/ip messages, but question is: Is possible to prepare any form of "WAKE UP" functionality, that automaticaly informs application: "YOUR DATA TABLE IS CHANGED - PLEASE UPDATE" immediately after change was made by one of other hosts

[Ikar]

MS SQL Server doesn't provide such functionality. However we could advise to use
instead of separate protocol table of messages at the server.