>Is there a way to determine if a table record has changed if that table does not have a datetime stamp? Right now I'm comparing the current table with a previous copy of the table to see if any data has changed.
>
>Can triggers do this instead? In other words, if a field is changed, can it trigger an update to a remote table that needs to be kept in sync? If so, what would that trigger look like?
>
>Thanks in advance.
An audit-trail is supposed to record all changes in a table. Mainly, you want to know what changes have been done, who did them, and when. And in what table too: for you can use a single audit table to check changes in your entire database.
I wrote an introductory article on how to do this, at
http://www.utmag.com/May2003/Page18.asp.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)