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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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

If you were running SQL Server 2008 R2 it would have instead of 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
  • on and so forth
share|improve this answer

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

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

Your Answer


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