Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I ran @@version.

This is what it gave me:

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)

How do I know if this is r2?

share|improve this question

migrated from stackoverflow.com Nov 17 '11 at 2:01

This question came from our site for professional and enthusiast programmers.

    
Your @@version output would say so: Microsoft SQL Server 2008 **R2** (SP1) - 10.50.2500.0 (X64) –  marc_s Nov 14 '11 at 21:59
add comment

2 Answers

If you were running SQL Server 2008 R2 it would have 10.5.xxx instead of 10.0.xxx. And it would also say Microsoft SQL Server 2008 R2 ....

You can always find out the named version by the major/minor build number:

  • 10.5 : 2008 R2
  • 10 : 2008
  • 9 : 2005
  • 8 : 2000
  • ...so on and so forth
share|improve this answer
add comment

Here's a nice comprehensive list of SQL Server version numbers.

http://www.sqlteam.com/article/sql-server-versions

share|improve this answer
    
thanks for the link. –  oJM86o Nov 14 '11 at 21:45
    
I dont get it i try to do an update to r2 but it gives me: [Error Message] The Instance ID 'MSSQLSERVER' is already in use by SQL Server instance 'MSSQLSERVER.INACTIVE'. To continue, specify a unique Instance ID. [Details] Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException: The Instance ID 'MSSQLSERVER' is already in use by SQL Server instance 'MSSQLSERVER.INACTIVE'. To continue, specify a unique Instance ID. ================================================================================ –  oJM86o Nov 14 '11 at 21:47
    
@oJM86o That's because you are trying to install an instance with the name MSSQLSERVER. That is the default instance which you must already have. It looks like you are doing an install, instead of an upgrade. There is a spot in the SQL Server Installation Center for Upgrading in the Installation section. –  Thomas Stringer Nov 14 '11 at 21:49
    
@shark that is what I am doing upgrading from 2008 to r2, the setup failed the first time so I am retrying and that is the error I receive....and I do want to upgrade the default instance. –  oJM86o Nov 14 '11 at 21:53
    
@oJM86o If the upgrade failed the first time, you may be stuck in some unstable, in-between state now. –  Joe Stefanelli Nov 14 '11 at 21:55
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.