Rixon,

The standard way of doing this in SQL 2000 is to either use the UPDATE() function or COLUMNS_UPDATED() function. The first uses the column name and the second uses a bitmask. COLUMNS_UPDATED() is more flexible if you have multiple columns to check. UPDATE() is fine if only one column to check.

HTH.

- Val Matison

>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.