How do I find out what SQL Server 2005 Service Packs are installed?


Hi.

I'm trying to determine what SQL Server 2005 service packs are installed on our server.

I've looked in Add/Remove programs in control panel, but it does not indicate what service packs are installed.

I've also tried using SELECT @@version, which gives the following:


Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Workgroup Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


I've also tried using:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY ('edition')

Which gives me this information:

9.00.1399.06
RTM
Workgroup Edition


How can I find out what SQL Server 2005 service pack is installed?

__________________
A.Rajesh Khanna

Hi ,

RTM means "Release To Manufacturing", i.e. no service pack. If you had installed a service pack, then SERVERPROPERTY('productlevel') would have said something like SP2 instead.

Hi,

You can see here for the detail service pack information for all versions of SQL Server 2005 and below.

__________________
Shaalini.S
Be the Best of Whatever you are...

Hi Bluesky and shaalini,

Thank you both for your help.

In using SELECT SERVERPROPERTY, I was doing the right thing. So, in fact I still have the RTM version installed on the server I am working on.

I think I know what happened. We have two servers. Our network admin seems to have updated the other server to SP3 over the weekend, when I thought he updated mine.


So for anyone else out there, this statement:

SELECT SERVERPROPERTY('productlevel')

... will tell you whether you have a service pack installed, or the original (RTM).

__________________
A.Rajesh Khanna

SQL is a database server. Most likely your video editing program utilizes it in the back end. Tons of applications use a SQL back-end, but I doubt very many of those apps are meant to be run on a desktop. They are usually server or hosted applications . SQL is one of the best database servers out there, and I have used it extensively. Usually you are going to see SQL used in a corporate environment as it is very robust and meant for multi-users.