October 2, 2002 at 3:55 pm
Is there a way to tell if a specify patch like MS00-048 has been applied to our SQL 7.0 server? Regardless of whether it was applied via a hotfix, or SP3?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
October 2, 2002 at 6:37 pm
Have you tried Microsoft Baseline Analyzer?
October 3, 2002 at 4:50 am
This tool is free and very usefull and fairly simple to read the output.
Microsoft Network Security Hotfix Checker (Hfnetchk.exe) Tool Is Available
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303215
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 3, 2002 at 7:20 am
To piggy-back on both of these guys...
HFNetChk is a command-line tool from Shavlik. Shavlik has a more robust version out called HFNetChk Pro (imagine that) which can also do patch management. That's the press on it, I've not tested the pro version.
Microsoft Baseline Security Analyzer (MBSA) is a GUI version. It'll produce an XML output. HFNetChk will produce a text file if you so ask, but it's not XML. Also, MBSA will perform additional checks such as looking for weak or non-existant passwords.
Both are available for download from Microsoft. http://www.microsoft.com/security/ is a good starting point.
Both work by pulling down a .CAB file from Microsoft which is then extracted to a .XML file. The .XML file does not include beta versions of service packs and the like, so keep that in mind if you do any of that sort of thing in your organization.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
October 3, 2002 at 8:20 am
Thank you for the tip. I will check these out.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply