Question How can I track changes to a database table

mgjaltema

New member
Joined
Jul 15, 2010
Messages
1
Programming Experience
3-5
Hello!

I hope somebody can help me. I have a MS SQL database with multiple tables, where one of the tables is really important. I have several clients simultaniously working with this table and the data should be consistent between the clients.

How can I make sure all my clients no that data in the table has changed. I'm preferring a "push" meganism instead of using a timer to pull the table... Who has done this before and can help me with trics or samples?

Thank you very very very much!

Marcel
 

jmcilhinney

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,169
Location
Sydney, Australia
Programming Experience
10+
There is no simple option. It has to be something initiated by the client because the server doesn't know who all the clients are. If the number of clients is small then you might look at the SqlDependency class. I've never completed an implementation so I can't give you the details, so you should start by reading the documentation and then look for examples.
 
Top Bottom