This very easy bit of code will call a VBScript script from a Windows Batch Script: call script.vbs
Continue readingHow to Create a Shortcut with VBScript
This script came in handy when I needed to roll out a desktop shortcut to every employee at the company I work for. The script […]
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 readingChanging the Maximum File Upload Size in IIS 6.0
Large file uploads in ASP.NET Uploading files via the FileUpload control gets tricky with big files. The default maximum filesize is 4MB – this is […]
Continue readingHow to Turn on xp_cmdshell for SQL 2005
The xp_cmdshell function can be very helpful for running commands on an SQL server. However, turning on the function comes with risks. I’ll discuss those […]
Continue readingScript to Add a New SQL Differential Backup Job With Daily Incremental Zip Archives
This script builds on the differential backup script, adding a zipped incremental backup. This script will create a zip file for each day of the […]
Continue reading