Articles

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2001-06-18

5,392 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2001-06-14

10,061 reads

Blogs

Mastering the ORDER BY Clause in SQL Window Functions

By

This article provides a comprehensive overview of the ORDER BY clause within SQL window...

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

By

Want to build a data analytics foundation that transforms raw data into valuable business...

Using SQL Compare in Read-Only Databases

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Read the latest Blogs

Forums

Logging from application to SQL server 2014..Using ODBC driver 18 for SQL SERVER

By SQL_Surfer

I'm using the below connection string using providing UserID and password on their respective...

Knowing Your Total Reward

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Knowing Your Total Reward

No Renames

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No Renames

Visit the forum

Question of the Day

No Renames

Which of these can't be renamed with sp_rename?

See possible answers