>>It looks like each one of the tables of my SQl Server database has a column timestamp_column of type timestamp. I don't remember adding this column. How could it have gotten there?
>>
>>Also, the Insert into a table fails pointing that Default should be used when inserting to timestamp_column. How do you do it?
>>
>>Thank you in advance.
>>
>>UPDATE: I found that not all tables have this column but a lot of them. Could this column been added by VFP wizard that converted VFP database to SQL Server? Is it then ok to delete this column?
>
>Here is a link to the M$ docs :
http://msdn2.microsoft.com/en-us/library/aa260631(SQL.80).aspx>The timestamp column is updated automatically on insert and update. This data type is usually used to version stamp a record. I am unsure how this collumn got added if you didn't do it.
>
>Einar
Correction. The link is not dead but when I simply click on it it forwards me to another link. But if I type the URL manually, I find the article. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham