Monthly Archives: July 2012

 In SQL Server 2000 we have to set the system marking to on with master.dbo.sp_MS_upd_sysobj_category. In SQL Server 2005 we have the sys.sp_MS_marksystemobject stored procedure that does the trick. SQL Server 2000: USE master — This turns the 2000’s system marking on EXEC master.dbo.sp_MS_upd_sysobj_category 1 go CREATE PROC SP_TestProc AS SELECT    * FROM    information_schema.tables — … Continue reading →

Set fso = CreateObject(“Scripting.FileSystemObject”) Set objShell = CreateObject(“Shell.Application”) Set f = fso.GetFolder(“c:\windows\system32”) ‘change directory name Set fc = f.Files For Each fs In fc If fso.GetExtensionName(fs) = “dll” then WScript.Echo fs.Name, fs.DateLastModified, fso.GetFileVersion(fs) End if Next Save script with a vbs extension and run from the command line as cscript scriptname.vbs