Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

Which version of SQL do I have

We have a DVD labeled SQL Server 2008 R2 and copied it contents to the server drive.  However after I installed it it comes up in SSMS saying just SQL Server 2008. On the setup.exe the version listed is 2007.100.1600.22. Is the setup program for SQL Server 2008 or SQL Server 2008 R2?
0
rwheeler23
Asked:
rwheeler23
1 Solution
 
Kent DyerCommented:
Gooogle version of SQL Server - there is a MSFT page of SQL server versions.
0
 
Steven HarrisPresidentCommented:
SQL Server 2008 RTM (release to manufacture)

This would be the MSDN/TechNet download version.

2008 R2 is a 10.50 variation.
0
 
Steve WalesSenior Database AdministratorCommented:
You can, from SSMS do this:

select @@version

With what's returned, refer here:

http://sqlserverbuilds.blogspot.com/

Referring there and seeing what you've posted, I'm thinking SQL Server 2008
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
rwheeler23Author Commented:
My question here is not what version is installed but what version is the DVD? The DVD says SQL Server 2008 R2 but the SQL installed on the server is SQL Server 2008. Is there any way to tell from the install media which version of SQL is on the DVD? All I can see is that when I right-click on the setup.exe on the DVD the version that is returned is 2007.100.1600.22. I am wondering if we were given a pirated copy of SQL.
0
 
Steven HarrisPresidentCommented:
All I can see is that when I right-click on the setup.exe on the DVD the version that is returned is 2007.100.1600.22. I am wondering if we were given a pirated copy of SQL.

The version you number you gave is SQL Server 2008 RTM which is a MSDN/TechNet download version.  This is not SQL 2008 R2, so if the media says otherwise, the copy is most likely altered.
0
 
rwheeler23Author Commented:
Great. Thanks. No one has any idea from where it came. I will let legal deal with this.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now