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 readingAuthor: kevin
Query 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 readingScript to Add a New SQL Differential Backup Job
I know you’ve been waiting for this… This script will add a differential backup job to Microsoft SQL Server 2005. Use this script in conjunction […]
Continue readingScript to Add a New SQL Backup Job
This script is for the times when I like to automate the task of adding database backup jobs to Microsoft SQL Servers. I’ll sometimes add […]
Continue readingCannot turn on the status bar in Notepad
Very helpful. Works on Windows XP: 1. Open Notepad and enable “Status Bar” from “View -> Status Bar”. If this option is disabled, then first […]
Continue reading