INF: No Timestamp Is Returned by dbtsnewval() If Update Fails (45261)



The information in this article applies to:

  • Microsoft SQL Server Programmer's Toolkit 4.2
  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q45261
The documentation states that the dbtsnewval() function returns the new timestamp value if the update is successful. The new timestamp is returned to the client as a by-product of the update. If the update is not successful, no timestamp is returned from the server. The dbtsnewval() function is provided to allow the application to adjust the timestamp value in the WHERE clause if a second update to the same row is to be performed.

Modification Type:MinorLast Reviewed:3/2/2005
Keywords:kbinfo kbprogramming KB45261