Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sbt1
Yak Posting Veteran
89 Posts |
 Posted - 2006-02-17 : 07:30:40
|
| I have a bunch of client machines that periodically query a database and update a schedule board.Is there a way, like maybe a field in some internal table, to determine the time & date that any database change was last made? That is, some way besides having my own table& field that every write would have to update?I'm hoping to have the clients test just that function, if no changes have occurred they would not go thru the database query and update process (saving lots of unneeded activity). |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-02-17 : 10:53:21
|
| triggers!...to update some control record...(or a calc-only column which might do a basic/complex hash-count of other records) |
 |
|
|
|
|
|
Possible to determine if any db change has occured