Installing Service Pack 1 for SQL Server 2000
Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don't let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide you a step-by-step guide to installing Service Pack 1 for SQL Server 2000.
Notes from the field - SP1 Personal Edition
Steve Jones provides some notes from the field after installing SP1 on a personal edition of SQL Server
Executing Multiple Scripts in a Folder using the ScriptRunner Utility
Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.
Security Alerts and Information
A new security alert affecting SQL Server was released on June 12, 2001
Implementing Data Quality Through Meta Data
Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.
Service Pack 1 for SQL Server 2000 Released
In this article by Brian Knight, he explores how to install Service Pack 1 for SQL Server 2000 and some of the catches. This service pack is one of the largest in SQL Server history. Learn what was fixed here.
Blogs
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I...
Daily Coping 26 Sep 2022
By Steve Jones
Today’s coping tip is to enjoy photos from a time with happy memories. On...
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Forums
3616 Trigger Error when Calling Stored Procedure on Linked Server
I am updating a proprietary database using an SSIS package. From a web UI...
Seggregating access within a database to users
For some folks that have gotten used to working in Oracle where a user...
Replication Error on identity Column : Transactional Replication
I have manually deleted data from a subscriber replicated table, and broken replication....
Ask SSC