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
 
Back
Top