snippetMinor
How to know if I am running SQL Server 2008 R2?
Viewed 0 times
know2008sqlrunninghowserver
Problem
I ran
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?
@@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?
Solution
If you were running SQL Server 2008 R2 it would have
You can always find out the named version by the major/minor build number:
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
Context
StackExchange Database Administrators Q#8003, answer score: 4
Revisions (0)
No revisions yet.