Solved

Which version of SQL do I have

Posted on 2014-02-05
6
299 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
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 SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now