SQL Server Magazine

		Options
Get the FAQs In this issue, get the FAQs about how to set up your shell scripting environment, determine whether a user is an administrator, and reset the username in a logon dialog box. Also learn how to write a script that detects directory differences and more.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Detect Directory Differences

Here’s a script that you can use to compare the files in two directories.
By Dave Roth 

Optimize the Size of Your Indexed Integer Columns

Together, the suggestIntType and scanIntIndex procedures search for indexed integer columns in a database and determine whether the optimal data type is used for those columns.
By Eli Leiba 

The FAQs About Setting Up Your Shell Scripting Environment

Learn the basics of setting up a Windows command shell scripting environment.
By Dick Lewis 

Using the Penton.VBSort Object to Sort Arrays

Here’s a command-line script that uses the Penton.VBSort object to sort an input file and write it to an output file.
By Bill Stewart 

Operators Are Leading Double Lives

VBScript’s logical operators can perform not only logical comparisons against text, numbers, and dates but also bit comparisons. Here’s a script that uses the AND operator to derive individual bit values from any decimal or hex number you specify.
By Readers 

Rem, May 2006

This month, learn how to determine whether a user is an administrator while addressing group-nesting and string-matching problems in searches and how to automatically set the DefaultUserName by using LastLogonName.vbs.
By Bill Stewart 

The Delay Function Extends WSH’s Sleep Method

This user-defined function works like the WScript.Sleep method but wakes the script up early if necessary.
By Jim Turner