dbTalk Databases Forums  

rowversion missing in sql server 2008

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss rowversion missing in sql server 2008 in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
redbull
 
Posts: n/a

Default rowversion missing in sql server 2008 - 06-25-2010 , 10:21 AM






Hi guys, im playing with sql server managemnent studio.
I cannot find rowversion type, but if I'm not wrong, yesterday it was in the
list :S
Is it possible?
How can I resume this type? Thanks

Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: rowversion missing in sql server 2008 - 06-25-2010 , 10:54 AM






redbull (redbull (AT) libero (DOT) it) writes:
Quote:
Hi guys, im playing with sql server managemnent studio.
I cannot find rowversion type, but if I'm not wrong, yesterday it was in
the list :S
Is it possible?
How can I resume this type? Thanks
I don't know why you would need it to appear in a list. If you need
to use the type, just use it. (But don't use the Table Designer if
that is what you are doing, but learn the syntax for CREATE TABLE.)

Else you could use timestamp which is a different name for the same
type. Microsoft has deprecated this name, but they have not even themselves
obeyed the deprecation.




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.