Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server timestamp use
Message
From
04/10/1999 17:58:19
 
 
To
04/10/1999 17:11:32
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00272478
Message ID:
00272488
Views:
42
SQL Server updates the timestamp column of a row whenever the information in the row is changed. It'll have no effects on performance unless you're accessing the timestamp column within your queries. Many developers use the timestamp to implementing optimistic locking. If the timestamp has a different value when you go to write the new data then it had when you read the data, someone else has made a change.

How are you trying to copy the tables? You can't explicitly place a value into a timestamp column. Try changing you copy routine to only place values into the columns that aren't timestamps (and identities).

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform