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

Yes, absolutely.

Depending on the trigger that gets fired, tables are created that contain copies of the data before and after the change. You can query these tables and compare them to the actual values to determine at that point what to do.

The key to making this work is having properly-defined primary keys. By this, I mean that you can get to the record that was changed. For example, assume we have a table 'Customers' with a PK name of 'iCustomerKey'. Your update trigger would look like this:

declare @iCustomerKey int
select @iCustomerKey = iCustomerKey from inserted()

declare @cOldName char(30), @cNewName char(30)
select @cOldName = cCustomerName from inserted()
select @cNewName = cCustomerName from customer where iCustomerKey = @iCustomerKey

if @cOldName <> @cNewName
   { do your stuff }

Obviously this can be tedious to code, but I hope you get the idea. Duffy is right, if you need auditing capability you might check out his product.