Here is a collection of stuff I use, both written by myself or more usually, found elsewhere.
SQL
VisualSourceSafe
Visual Basic (& other WSH/Batch type scripts)
- SQLJobsReport — SQL Agent Jobs Report, written in VBScript that outputs to an html file. This can be setup to report on many servers.
- Backup Enterprise Manager Settings
- RestoreSQLViaDMO
- BackupTimeShiftedServers
- CopyLatestDatabaseBackup — This script copies the latest file in a folder, and each sub-folder, & copies them to a different location, renaming the files after the name of the folder containing them, so only the most up to date files are backed up.
- Common.vbs — My commonly used VB functions
- Include.vbs — An example template that includes the above file. To be honest, I usually Cut ‘n’ Paste functions from Common.vbs.
- WS56QREF.HTA — This rather cryptically named file is a HTA, a HTLM Application. It looks for the Windows Help file Script56.CHM, in my case in
C:\Program Files\Microsoft Windows Script\ScriptDocs, and creates a very nice index page, letting you look up any WSH, JScript, VBScript, FSO or WSC command with ease.
- Unblock CHM Files
- RunCommandAgainstServerList — A VBScript that runs a command contained in a text file
CommandFile.Txt, against a list of servers contained in another, ServerList.Txt
- ServerChecks — Another multi-file solution that checks the event logs & disk space against a list of servers held in
ServerList.Txt
- PrintMultipleMultiPageTIFFFiles
- CheckDatabaseBackups
- DynamicExcelCharts
- CreateDailyWorkingFolder
- GrepForWindows
- PurgeFiles — Good script for deleting files on a time basis, but use with care!
- List Services
- List Tables used in All your Crystal Reports
- Extract Mail and UnZip Attachment
- Update SQL Tables from Excel Matrix
- Excel Macro to alternate row colour Depending on Data
