how to check if a table has been updated?

  • Thread starter Thread starter buu
  • Start date Start date
B

buu

So, is there any way to check that any table has been updated through app?
Is the only way for that to put some triggers on tables and to create some
'notification table'?
 
Typically yes, however depending on whether your app is a windows forms app
or a web application being hosted in IIS you can take advantage of the new
functionality SQL server 2005 has. I believe they're called notification
services, but I could be wrong.

Using some kind of notification table with triggers is probably the most
widely used approach to this common problem.
 
Buu,

As everything in programming you have to trust when it is done and you have
set the proper error trapping around it.

In a way this questions looks like.

How can I be sure that in my program 1+1 = 2

(Some people use endless testing for that, which was needed when everything
was still mechanical, now there is a change of 1 to nothing that it fails).

Cor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
Unread e-mail count in Samsung Oreo update 3
Canon IP 6600D Photo Printer 2
VBA - retrieve data on last create named range from previous inserted named range 0
Check if a linked table in the database has been updated/changed 1
How to unlink TOC from a doc 0
How to Populate Data from a table to another 0
What are these please? 2

Back
Top