how to check for installed patches

Question

Post reply

how to check for installed patches

sahmad43

SSC Eights!

Points: 926
More actions
February 9, 2009 at 3:19 pm

#94565

how can I see if my sql server is having the latest greatest patches ?

Viewing 13 posts - 1 through 12 (of 12 total)

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

Bob Griffin SSCertifiable Points: 5982 More actions · Answer 1

select @@version

it's a very long result with the service pack info at the end....

sahmad43 SSC Eights! Points: 926 More actions · Answer 2

(Build 3790: Service Pack 2)

this is what I see .. does it mean I have the latest patch applied ? what build or version number is the latest ?

Bob Griffin SSCertifiable Points: 5982 More actions · Answer 3

sp 4 is the latest for sql 2000

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

sahmad43 SSC Eights! Points: 926 More actions · Answer 4

so is this security path including in SP4 and I dont need to worry about it ?

Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB960083)

DHeath SSCertifiable Points: 5200 More actions · Answer 5

check here this is an excellent place for patches and dates

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

-D

DHeath

Bob Griffin SSCertifiable Points: 5982 More actions · Answer 6

Check the release dates. The security patch needs to be applied after sp4 is applied

sahmad43 SSC Eights! Points: 926 More actions · Answer 7

thanks that link was very usefull , just the right info I needed

sahmad43 SSC Eights! Points: 926 More actions · Answer 8

if SP4 is seperate from security patches how do I know if that security patch is applied to the database or not ? this puts me back to squre one :

based on the information below can I see if the latest security patch has been applied or not? knowing that 8.00.2050 means SP4 .

Bob Griffin SSCertifiable Points: 5982 More actions · Answer 9

Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB960083)

This patch is specifically for sp4. Technically since you don't have service pack 4, you don't need this patch...however, you do need to get your service pack level updated simply because this is a best practice. Once you apply sp4, you will then need to run the KB960083 patch. Patches and service packs all work together.

sahmad43 SSC Eights! Points: 926 More actions · Answer 10

hi Bob !

you said 'I dont have service pack4' but I do have SP4 , if I check the database properties it says SP4 ?

sahmad43 SSC Eights! Points: 926 More actions · Answer 11

and let me put the question in this way : If I have SP4 applied how can I see if KB960083 patch has been applied or not ?

Bob Griffin SSCertifiable Points: 5982 More actions · Answer 12

Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2
(Build 3790: Service Pack 2)
this is what I see .. does it mean I have the latest patch applied ? what build or version number is the latest ?

According to your previous post you have service pack 2 applied. However, if you have a server with service pack 4 and you want to verify that this update has been applied you can compare the file versions on your server to the files listed here:

http://support.microsoft.com/?kbid=960083

Also you can attempt to run the patch. Normally if it's already installed, the patch program will tell you. This is something I would do only on a non production database though.....