This script helped me configure an enterprise monitoring system. I created little events in the Windows event log and monitored the events using the syslog […]
Continue readingCategory: Windows
Windows
T-SQL Stored Procedure Research
Whenever I am researching stored procs, I try to remember the following queries: Search within a stored proc. Useful when trying to understand what stored […]
Continue readingRetrieve Model and Serial Number with VBScript
Simple script to retrieve information about a workstation or hardware. strComputer = “.” Set objWMIService = GetObject(“winmgmts:” _ & “{impersonationLevel=impersonate}!\\” & strComputer & “\root\cimv2”) Set […]
Continue readingPass Parameters from a Windows Batch Script to VBScript
It can be very useful to pass parameters from a Windows Batch Script to VBScript. For this to work, a user will pass parameters to […]
Continue readingCall VBScript from a Windows Batch Script
This very easy bit of code will call a VBScript script from a Windows Batch Script: call script.vbs
Continue readingList Databases from an SQL 2005 Server
There are a number of ways to list databases from an SQL 2005 Server. — Easiest way is to use the undocumented SQL 2005 stored […]
Continue readingTransfer SQL Logins to Another SQL 2005 Server
After you move a database from one instance of SQL 2005 to another instance of SQL 2005, the users may not be able to log […]
Continue readingQuery for the Citrix Server List
SQL query for the Citrix server list. Substitute the dbid for the current id or simply use the name: select rtrim(hostname) as hostname, rtrim(program_name) as […]
Continue readingTransfer SQL Logins to Another SQL 2000 Server
The following script will transfer logins and passwords from one SQL 2000 server to another. This script is intended to be used in the rare […]
Continue readingScheduling a Backup Job in Microsoft SQL 2005 Express Edition
SQL 2005 Express Edition does not offer a way to schedule jobs. The following steps outline a way to schedule jobs in SQL 2005 Express […]
Continue reading