Board index » delphi » how to get the MS SQL's database data change notify immediately?

2003-12-05 09:47:34 AM
delphi271
hi all,
My problem is, my user may use third part program, even some like "Query
Analyzer" program to update the database's data, so, how can my program get
the exact data changed notice immediately?
Now,for my program can to keep the fresh data, I use a timer to do the
query round and round. but this way is inefficient! Are there any better way
to reach my goal?
Regards,
Ari
 

In SQL 2000 you would have to use Triggers or SQLTrace, neither of which is
a particularly clean solution. In Yukon you could use Query Event
Notifications.
-Euan
"ari" <XXXX@XXXXX.COM>writes