Solved

SQL Version Am I Running?

Posted on 2013-01-03

Microsoft SQL Server

2 solutions

417 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?

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

Join The Community

3 Comments

LVL 30

Assisted Solution

by:Randy Downs

Randy Downs earned 250 total points

ID: 387408002013-01-03

Maybe this will help

http://support.microsoft.com/kb/321185

LVL 10

Accepted Solution

by:bigbigpig

bigbigpig earned 250 total points

ID: 387408652013-01-03

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.

LVL 3

Author Comment

by:Bransby-IT

ID: 387409412013-01-03

Bigbigpig, thanks very much.

Been a while.....

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

Thanks very much.

Featured Post

Question has a verified solution.

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

Things To Know About Local Load Balancing

Article by: Tony

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.

Installing SQL Server vNext on Linux: Part 1 (Prerequisites)

Article by: Yashwant

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.

Basic Housekeeping for SQL Server

Video by: Steve

Via a live example, show how to setup several different housekeeping processes for a SQL Server.

Microsoft SQL Server

SQL - Inserting Data

Video by: Zia

Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.