Re: SQL Server HotFix verification

From: Ken Schaefer (kenRMV@THISadOpenStatic.com)
Date: 09/26/02 

From: "Ken Schaefer" <kenRMV@THISadOpenStatic.com>
Date: Thu, 26 Sep 2002 14:19:10 +1000

SELECT @@VERSION

?

(as per: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316333)
Also, the file you download and extract (the MS02-043 Roll up patch is named
the same as what SELECT @@Version should report)

Cheers
Ken 

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Rob" <rhchin@hotmail.com> wrote in message
news:8fd601c264ca$f6b7d790$3bef2ecf@TKMSFTNGXA10...
> Is there a way to identify what SQL Server Hotfixes are
> installed on a server?
>
> For the OS, this information can be located in the
> registry key:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows
> NT\CurrentVersion\Hotfix
>
> Which Registry Key would this information be stored in for
> SQL Server Hotfixes. I scanned through my entire Registry
> but could only identify for the OS level.
>
> Someone had suggested using Microsoft Baseline Security
> Analyzer. However, this tool only tells you what should be
> installed in order to be security compliant... NOT, what
> Hotfixes are currently installed on the server.
>
> Thanks for your responses