VBScript: Bypass the "Open File – Security Warning" dialog from VbScript

You have had it before: the “Open File – Security Warning”. Nice feature, but not very interesting during execution of scripts. However you may not want to turn it off.

The simple solution in VBScript has been offered by MS themselve: the SEE_MASK_NOZONECHECKS environment variable. Change it at the start of your script and restore it at the end. Plain & simple!

Sample code (same as the KB article):
set oShell= CreateObject(“Wscript.Shell”)
set oEnv = oShell.Environment(“PROCESS”)
oEnv(“SEE_MASK_NOZONECHECKS”) = 1
oShell.Run “c:\ms04-038\WindowsXP-KB834707-x86-enu /quiet /passive /norestart”,0,True
oEnv.Remove(“SEE_MASK_NOZONECHECKS”)

The Open File – Security Warning dialog box is displayed when you try to silently install a hotfix or an update by using a Visual Basic script in Windows XP Service Pack 2
http://support.microsoft.com/kb/889815

Important fix for ePO 3.6.x

Recently we had an issue on our ePO 3.6.x servers. In the CMA logs we found “ePO Server reached the maximum download limit”.

After some investigation we found a KB on the McAfee website documenting this related to Apache included in ePO installation.

My advise: apply it if running ePO 3.6.x by default.

ERROR: ePO Server reached the maximum download limit (issue: Apache configuration)
https://knowledge.mcafee.com/SupportSite/search.do?cmd=displayKC&docType=kc&externalId=9227574&sliceId=SAL_Public&dialogID=26664547&stateId=1%200%2026656632

How to identify SQL version & build…

Some time ago I needed to easily find the SQL version & build installed on a machine to identify missing patches. Below the links that will tell you everything you need about this!

Microsoft SQL Server 2008, 2005, 2000 and 7.0 Builds
http://sqlserverbuilds.blogspot.com/

How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/

Also some registry keys that could be easy when you write custom scripts.

SQL Server 2005 Express
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion — CurrentVersion — REG_SZ