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 readingCategory: SQL
SQL
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 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 readingInactive Replication Subscriptions
If database replication has been disconnected for too long, the subscription may become inactive. The error message may read: “The subscription(s) have been marked inactive […]
Continue reading