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)