Solved

SQL Version Am I Running?

Posted on 2013-01-03
3
413 Views
Last Modified: 2013-01-03
I am running SQL Server 2008 but how can I tell what version it is / Service Packs.

I have the version 10.0.1600.22

I am installing a new SQL Server and am ready but I can only see "SQL 2008 Standard Edition SP3" on my Volume Licence Site but I just want to make sure its not R2 or is this the same?
0
Comment
Question by:Bransby-IT
[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
3 Comments
 
LVL 30

Assisted Solution

by:Randy Downs
Randy Downs earned 250 total points
ID: 38740800
0
 
LVL 10

Accepted Solution

by:
bigbigpig earned 250 total points
ID: 38740865
10.00.1600 is SQL 2008 with no service packs.  If it was SQL 2008 R2, which is not the same, it would be 10.50.xxx.
0
 
LVL 3

Author Comment

by:Bransby-IT
ID: 38740941
Bigbigpig, thanks very much.

Been a while.....

My confusion was in my VMCenter there was an ISO with the 2008_R2.

Thanks very much.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

738 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