Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - how to check if a table has been updated?

Reply
 
Old 06-21-2008   #1 (permalink)
buu


 
 

how to check if a table has been updated?

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'?



My System SpecsSystem Spec
Old 06-21-2008   #2 (permalink)
Jeff Winn


 
 

Re: how to check if a table has been updated?

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" <aha@xxxxxx> wrote in message
news:1214071782.646461@xxxxxx
Quote:

> 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'?
>
My System SpecsSystem Spec
Old 06-22-2008   #3 (permalink)
Cor Ligthert[MVP]


 
 

Re: how to check if a table has been updated?

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

"buu" <aha@xxxxxx> schreef in bericht
news:1214071782.646461@xxxxxx
Quote:

> 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'?
>
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
spell check wont check english/ Vista mail
Typed datasets and table table adapters components not showing inToolbox .NET General
how do you create a dynamic table/pivot table .NET General
Newbie: Nagios with nrpe_nt, check for diskspace; check services,returncode PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46