The easiest way on sql server 2000 is to change the collation on the column you want to do the search on:

ALTER TABLE dbo.Customers ALTER COLUMN CustID char(8) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL

Why bother with a best practice if a simple copy-paste is much faster. Migrating SQL server 2000 to a new machine.