 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
ari
Guest
|
 Posted: Fri Dec 05, 2003 1:47 am Post subject: how to get the MsSql's database data change notify immediate |
 |
|
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
|
|
| Back to top |
|
 |
ari
Guest
|
| Posted: Fri Dec 05, 2003 5:00 am Post subject: I think I need some functions like the "Sql Profiler" progra |
|
|
I think I need some functions like the "Sql Profiler" program, but most
simpler.
for me, I just need to get the specifical table's changed message!
|
|
| Back to top |
|
|
Euan Garden
Guest
|
| Posted: Fri Dec 05, 2003 7:57 pm Post subject: Re: how to get the MsSql's database data change notify immed |
|
|
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" <aiirii (AT) 163 (DOT) net> wrote
| Quote: | 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
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
