TimeStamp and @@DBTS feature/syntax deprecated in future version, what is the alternative provided by SQLServer

• iBar

  SSCertifiable

  Points: 5872

  More actions

  January 20, 2012 at 5:58 am

  #391366

  HI,

  As mentioned in the this link that don't use TimeStamp feature in future development.

  http://msdn.microsoft.com/en-us/library/ms182776.aspx

  What is the alternative provided by the SQL server?

  NB: Separate question may be but we want to use this in NHibernate. What do you suggest?

  Thanks.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  January 20, 2012 at 6:51 am

  #1436451

  Rowversion is the alternative to TimeStamp.

  TimeStamp was badly named in the first place. The data doesn't have any real relation to time stamps, it's just a row version increment.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  January 20, 2012 at 7:40 am

  #1436493

  TIMESTAMP is now a synonym in 2012. Just saw that the other night.

  Like Gus says, ROWVERSION is the replacement. It's basically the same thing.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning