Solved

Which version of SQL do I have

Posted on 2014-02-05
6
310 Views
Last Modified: 2014-02-05
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
Comment
Question by:rwheeler23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 17

Expert Comment

by:Kent Dyer
ID: 39837656
Gooogle version of SQL Server - there is a MSFT page of SQL server versions.
0
 
LVL 18

Expert Comment

by:Steven Harris
ID: 39837662
SQL Server 2008 RTM (release to manufacture)

This would be the MSDN/TechNet download version.

2008 R2 is a 10.50 variation.
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39837687
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
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 

Author Comment

by:rwheeler23
ID: 39837803
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
 
LVL 18

Accepted Solution

by:
Steven Harris earned 500 total points
ID: 39837805
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
 

Author Closing Comment

by:rwheeler23
ID: 39837808
Great. Thanks. No one has any idea from where it came. I will let legal deal with this.
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question