SQL 2008 Still Shows Timestamp, not RowVersion - by Larry Burns

Status : 


Sign in
to vote
ID 530944 Comments
Status Active Workarounds
Type Bug Repros 11
Opened 2/4/2010 11:47:21 AM
Access Restriction Public


I added a concurrency column to a SQL 2008 table, using the new 'rowversion' datatype.  I was able to add the column, but it shows as type 'timestamp', not 'rowversion'.  The table designer in SQL 2008 Mgt Studio doesn't even have rowversion in the drop-down list of datatypes.  I've verified that the compatibility level of the database is SQL 2008.  Why am I not seeing 'rowversion'?  Here is the output from @@VERSION"

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) 
	Mar 29 2009 10:11:52 
	Copyright (c) 1988-2008 Microsoft Corporation
	Standard Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)
Sign in to post a comment.
Posted by Microsoft on 2/1/2013 at 11:37 AM
I have resolved this as duplicate of below:


This is an issue in the engine since ROWVERSION is just an alias for TIMESTAMP in the Parser. The name "ROWVERSION" doesn't make it through to the other parts of the engine like metadata or schema.

Umachandar, SQL Programmability Team
Posted by Vachhrajani, Nakul on 6/30/2012 at 10:57 AM
Isn't this a duplicate of: http://connect.microsoft.com/SQLServer/feedback/details/274333/
Posted by Larry Burns on 2/17/2010 at 2:28 PM
One other issue: when I add a column with type 'rowversion', and then extract the DDL in Mgt Studio, the extracted DDL shows the column with datatype 'timestamp', not 'rowversion'.