INF: Forcing Update by Overriding Timestamp Protection

ID: Q45262


The information in this article applies to:
  • Microsoft SQL Server for OS/2, version 4.2

If an update issued by user 1 during a browse fails because user 2 has updated the record since user 1 read it, you can optionally override the timestamp protection and force the update to occur by issuing the update without the timestamp qualification in the WHERE clause. If user 2 has changed the columns(s) that uniquely identify the row, the update results in a "not_found" error. Then do an insert.

Additional query words: Transact-SQL

Keywords : kbother SSrvServer
Version : 4.2
Platform : OS/2
Issue type :


Last Reviewed: March 6, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.