Michel,

The timestamp field is a very specialized field intended to be used only to determine if a record has changed since it was last accessed. It is not a good way to store information about the time a record was added or changed. For that purpose, use datetime fields. You can have as many of them as you want.

>In SQL Server 6.5, how do we proceed to add 2 timestamp fields in a table?
>
>In Visual FoxPro, this is a piece of cake. We can have multiple datetime fields in one table. However, on SQL Server, as soon as we try to add another timestamp field, we get an error which tell us that this is because we can only have one timestamp field.