Sergey, the examples don't give me any idea on how to do it, they just explain how to update other tables but in a batch way. I can´t know what record has changed, it only give me examples on knowing columns states, so would it be difficult to do it? I would do it in a VFP store procedure but those don't allow me to update the same table that the trigger belongs to.

Thanks, I hope you or somebody else can help me with this.

Luis


>Hi Luis,
>
>Go to SQL BOL and read CREATE TRIGGER. There're a bunch of examples included with it.
>
>>Hi friends!
>>
>>I have to update a datetime field whenever any other field of certain record has been modified so I know when that record was last modified. I know that I should use a trigger for update but I can't find a way to do it. I use remote views in VFP. My database is SQL Server 2000. Any help would be appreciated.
>>
>>TIA.
>>
>>Luis