Service Pack Detection

Question

Post reply

Service Pack Detection

Whisper9999

Hall of Fame

Points: 3012
More actions
November 3, 2008 at 12:17 pm

#125694

How can you tell in Sql Server 2005 what service pack you have on the client? In other words, I want to know if I installed SP2 on my laptop but am not sure how to find that out. I think I did but am not absolutely certain...

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Adam Bean One Orange Chip Points: 26631 More actions · Answer 1

Adam Bean

One Orange Chip

Points: 26631

November 3, 2008 at 12:50 pm

#893210

SELECT SERVERPROPERTY('ProductLevel')

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

you'll have to check the dll library of sql2005 at client level.

WMI softwarelist may also help out.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 3

You don't have to look at the DLL's to know whether a patch has been applied. The build number from SELECT @@Version can be used to figure out what patch(s) have been applied to any SQL Server Instance. Just cross reference the value to the list on this post:

http://www.sqlservercentral.com/articles/Administration/2960/

Steve keeps that list pretty up to date as new releases come out.

Adam Bean One Orange Chip Points: 26631 More actions · Answer 4

Why bother with the dll's?

SELECT SERVERPROPERTY('ProductLevel') = service pack level

SELECT SERVERPROPERTY('ProductVersion') = build revision

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 5

Actually ALZDBA has the more correct answer, since the original post wanted the client side version, not the server side version. If your laptop has Management Studio, an easy way to tell is to query a table that has a NULL value in it somewhere. In SP2, Management Studio highlights NULL values in the results grid in a pale yellow (info background color).

I've got SP2 and Help/About reports Management Studio as being version 9.00.3042.00

Whisper9999 Hall of Fame Points: 3012 More actions · Answer 6

Whisper9999

Hall of Fame

Points: 3012

November 3, 2008 at 2:12 pm

#893267

This will give server side, not client side, right?

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 7

Client side, in Management Studio you can use Help --> About which will output:

Microsoft SQL Server Management Studio9.00.3042.00

Microsoft Analysis Services Client Tools2005.090.3042.00

Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

Microsoft MSXML2.6 3.0 4.0 5.0 6.0

Microsoft Internet Explorer6.0.2900.5512

Microsoft .NET Framework2.0.50727.3053

Operating System5.1.2600

Which you can then compare to the list above as well. If SSMS is not installed, but the Client Components are you can look at the following Registry path with RegEdit:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup

the PatchLevel and Version keys under this path will have the appropriate build information for the tools.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 8

That's even easier than I thought. (using the help/about in ssms) :hehe:

The WMI query results to :

Display Name: Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU (KB921896)Install Date: 20071219 Version: .

This would make it easy to produce an inventory for all clients.

Have a look at http://www.microsoft.com/technet/scriptcenter/scripts/apps/user/usapvb06.mspx