SQL Server 2000 Build List

A list of builds and KB articles for SQL Server 2000.

create jobs script for 2000 2005 or 2008

will create jobs script for backup or DR purposes to install on another server.

SSIS Package to Script All SQL Server Jobs to Individual Files

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.

How to use Database mail feature in SQL Server 2000

This article describes a way by which we could use the feature of database mail in SQL Server 2000 itself which is a lot easier than SQL Mail.

Upgrading Replication from SQL Server 2000 32-Bit to SQL Server 2008 64-Bit without re-initialization

In this article we summarized the experiences we gathered during the planning and upgrade of a customer's project. The customer is one of the largest retail shops in its area. Their architecture is made up of a main server, which is located at headquarters and hosts several hundred publications containing over a thousand articles. Regional stores are located all over the country acting as subscribers for the publications hosted on the main server. Based on the business needs and infrastructure limitations the customer set the following goals for the project:

How to simulate transparent data encryption (TDE) with SQL 2000 and 2005

Encryption of data at rest is becoming more and more crucial in today’s world. This tip is aimed to help businesses that do not have the budgets or resources to purchase hardware encryption tools or to upgrade to SQL 2008. It basically illustrates how to achive transparent file encryption with SQL 2005 or SQL 2000.

Deleting Large Number of Records

Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005

SQL 2000 datafile locations

This script pulls all data and log files associated with user db's

Truncating the log

Enhancing the readability of your code: Table aliasing in sql

When writing SQL, picking good tables aliases can greatly enhance the readability of your code