SQL Server has a feature called query notification. It will send a message to the application when the underlying data becomes stale. Be careful, though, if you have many active clients and frequently changing data as it can add a significant load to the server.
Michael Green
- 923
- 5
- 17