SQL SERVER 2008 R2

[R7Dave]

Hello

I am trying to document my sql server info

How can I tell if my SQL installation is SQL Server 2008 or SQL Server 2008 R2?

If I run

SELECT SERVERPROPERTY ('productversion') AS Version

I get 10.0.4000.0

and according to the SQL Server release history,

10.0 = 2008 SQL Server 2008
10.5 = 2010 SQL Server 2008 R2

So does this mean I am running SQL Server 2008?

However, the senior DBA has this listed as SQL Server R2

I have tried many server properties but can't seem to find the correct one. Any help/advice appreciated.

Thanks
Dave

 

[gmmastros]

When I run "Select @@Version", I get:

[tt]Microsoft SQL Server 2008 [!]R2[/!] (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) [/tt]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Take a look at these two links

http://berezniker.com/content/pages...-server-edition-version-and-service-pack-info

http://blogs.msdn.com/b/pamitt/p/sql_version_history.aspx

- this lists all versions with dates


PluralSight Learning Library