January 27, 2010 at 12:39 pm
Hi folks 🙂
Windows Update has Microsoft SQL Server 2008 Service Pack 1 (KB968369) as an optional update, but the only problem is that I thought I had already installed it awhile ago.
My PC is a 64-bit Vista Ultimate machine and I am using the Express Edition of SQL Server 2008.
Some time ago it showed up in the list, so I made several attempts to install it, all to no avail.
If I remember correctly, I eventually worked out that I had to download/install the SP1 of the full version, so I did this and it seemed to go fine.
I have run two queries as follows:
SELECT @@VERSION AS 'SQL Server Version'
This returned the following result:
SQL Server Version
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) /quote]
-------------------------------------------------
SELECT
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('EngineEdition') AS EngineEdition;
GO
ProductVersion ProductLevelEdition EngineEdition
10.0.2531.0 SP1 Express Edition with Advanced Services (64-bit)4
-------------------------------------------------
These two queries as I understand it, seem to show that I do have SP1 installed.
So, I am confused :unsure:. If somebody could enlighten me I would really appreciate it.
Kind regards
Ross
January 28, 2010 at 6:24 am
Is it possible that you have 2 instances of SQL Server installed? One may be patched and the other may not.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply