Home Dashboard Directory Help
Search

SQL 2008 Still Shows Timestamp, not RowVersion by Larry Burns


Status: 

Active


26
0
Sign in
to vote
Type: Bug
ID: 530944
Opened: 2/4/2010 11:47:21 AM
Access Restriction: Public
0
Workaround(s)
view
11
User(s) can reproduce this bug

Description

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)
Details
Sign in to post a comment.
Posted by Microsoft on 2/1/2013 at 11:37 AM
Hello,
I have resolved this as duplicate of below:

http://connect.microsoft.com/SQLServer/feedback/details/274333/

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'.
Sign in to post a workaround.