October 5, 2005 at 1:34 pm
Is there a way to find out if the security patches were applied? Thanks!
October 5, 2005 at 2:06 pm
From QA run 'select @@version'. There is a list of what the corresponding SP levels mean here:
http://www.sqlservercentral.com/columnists/dPriyankara/versionservicepack.asp
Hope this helps.
My hovercraft is full of eels.
October 5, 2005 at 2:30 pm
Thanks. I want to know how to check the patches that were applied.
October 5, 2005 at 3:25 pm
Then I'll assume that you're speaking about operating system patches as the last patch that I know of for SQL Server 2000 was 03-031 released in 2003. I've you've installed SQL Server SP3a or 4 (but please check with vendors for compatibility before installing 4 as you may break things) then SQL Server is pretty much up to date.
To view OS security patch status you can open a Remote Desktop connection to the server, go to Control Panel, add/remove programs and see what's installed there, but you have to go the the KB number as that's what shows up there. You can also download Microsoft's Baseline Security Analyzer here: http://www.microsoft.com/downloads/details.aspx?FamilyID=4b4aba06-b5f9-4dad-be9d-7b51ec2e5ac9&displaylang=en&Hash=7F5N9W and scan the machine for current patch status and numerous OS vulnerabilities and others including SQL Server and IIS. This does a pretty good job and will show you other places besides patches where your machine may be vulnerable. Hope this helps.
My hovercraft is full of eels.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply