Get all changes?

I have a db on my SQL 7.0 I want to write an application in VB 6 which will monitor a table. I'd like
to see all changes upon that table (even those made by others) in real time. How can I instruct the
SQL server to PUSH those changes to my form? Could this be done?

I appreciate any toughts.
cunirosAsked:
Who is Participating?
 
TimCotteeHead of Software ServicesCommented:
You could write a trigger which logs the changes to a seperate table and poll this table on a frequent basis. Doing it realtime would be a bit of an interesting problem. I would imagine that you could write an extended stored procedure that would be called by your trigger to access an activex exe on your machine which would be able to fire back the event to your application but this is a fairly complex task. I would doubt that you really need this in real time, a simple polling of the table written to by the trigger once every 30 seconds or every minute would probably be sufficient. If you needed better resolution you could make this polling period flexible so that you can get frequent updates for a period and then slow it back down. Obviously network performance is likely to suffer if you are polling this table on a high frequency.
0
 
cunirosAuthor Commented:
Tim,

The table will be updated by other apps and I want to monitor all changes as they happen through this app I want to write, in real time.

Thank you.
0
 
DanRollinsCommented:
Hi cuniros,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept TimCottee's comment(s) as an answer.

cuniros, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 
NetminderCommented:
Per recommendation, force-accepted.

Netminder
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.