One of the new datatypes introduce with SQL Server 2008 is rowversion. This will be the replacement for timestamp data type. This is automatically generated, unique binary numbers within a database. rowversion is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes. The rowversion data type is just an incrementing number and does not preserve a date or a time. One of the best uses of this is for identifying delta changes.

The timestamp datatype is deprecated. This will be removed in a future version of Microsoft SQL Server. Avoid using timestamp in new development work, and plan to modify applications that currently use this.

Unfortunately this data type is not listed in SSMS.



Rakesh Mishra

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook