SQL Server Home
SQL 2008 Still Shows Timestamp, not RowVersion
2/4/2010 11:47:21 AM
User(s) can reproduce this bug
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)
SQL Server 2008 SP1
Windows Server 2003 (all x64 editions)
Operating System Language
Steps to Reproduce
Create a table in a SQL 2008 database, then run the following command: ALTER TABLE <tablename> ADD <columnname> ROWVERSION. Look at the table in Object Explorer or Designer. You will see the column name has been added, but the datatype is "timestamp", not "rowversion". Now, try to add the column manually in the Designer. You are not allowed to select "rowversion" from the drop-down list of datatypes.
You can create the column (i.e., the ALTER TABLE statement completes successfully), but the added column is of type "timestamp", not "rowversion".
I expected to see the added column with datatype "rowversion" in both Object Explorer and in the Designer. I also expected to be able to add a column of datatype "rowversion" in the Designer.
to post a comment.
Please enter a comment.
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
on 6/30/2012 at 10:57 AM
Isn't this a duplicate of: http://connect.microsoft.com/SQLServer/feedback/details/274333/
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'.
to post a workaround.
Please enter a workaround.
© 2013 Microsoft