Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-27 : 07:54:50
|
| Yiannis writes "Is there any SQL Server event or any other way so that a client can understand that a record in a table has been updated by another client and automatically call the refresh method in order to synchronize it with the updated underlined table ?Thanks in advance.Demetrakopoulos YiannisAnadelta Information & Medical SsytemsAthensGreece" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-27 : 08:37:17
|
| Well, you could use an update trigger to tell when the table was updated and have that trigger call the refresh method. Some better ways depending on your data latency parameters would be:1. Put your database in a cluster.2. replication3. Log shippingMike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Automatically Refresh a recordest when a record is updated.