6

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?

1
  • Your @@version output would say so: Microsoft SQL Server 2008 **R2** (SP1) - 10.50.2500.0 (X64)
    – marc_s
    Nov 14, 2011 at 21:59

2 Answers 2

4

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
3

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

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

6
  • 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, 2011 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. Nov 14, 2011 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, 2011 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, 2011 at 21:55
  • @oJM86o manu-sqlserverblog.blogspot.com/2011/09/… Check out that link. Looks like that might have your solution. Nov 14, 2011 at 21:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.