Determine SQL version.

nav2567
nav2567 used Ask the Experts™
on
Hello,

I have two SQL server which I need to determine their SQL versions.  Here is what I got using the sql@@version command.  

Can someone suggest a good weblink to look them up?


Microsoft SQL Server 2008 (SP3) - 10.0.5538.0 (X64)
                Apr  3 2015 14:50:02
                Copyright (c) 1988-2008 Microsoft Corporation
                Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)
 

Microsoft SQL Server 2012 (SP4-GDR) (KB4057116) - 11.0.7462.6 (X64)
                Jan  5 2018 22:11:56
                Copyright (c) Microsoft Corporation
                Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dustin SaundersCo-Founder and Chief Architect
Top Expert 2016

Commented:
I guess, what is it that you need that this isn't showing?

They're both SQL Standard, one 2008 SP3 and the other 2012 SP4

Author

Commented:
I am trying to see if it is SQL2008 R2
You may look at this link: https://sqlserverbuilds.blogspot.com/

Or are you really looking for the SQL (Structured Query Language) version?
If yes, then each SQL Server version has its own SQL (backward compatible) dialect and the documentation is structured by the SQL Server version, e.g. https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-2017
Dustin SaundersCo-Founder and Chief Architect
Top Expert 2016

Commented:
I am trying to see if it is SQL2008 R2

It's 2008, that command would show you "2008 R2" if it were such.
Doug BishopDatabase Developer

Commented:
Your 2008 version is 2008 SP3. There was an SP4 service pack that came out in September 2014, which was the last release for 2008. The last version for 2008 R2 also, coincidently, came out in September 2014.
2008 versions are 10.0.xxxx.x and 2008 R2 versions are 10.50.xxxx.x. The latest 2008 version is 10.0.6000.29 and the latest R2 version is 10.50.6000.34.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial