How can we install SQL 2000 on newly installed windows
2003 server while maintaining

During the install you have the option of going into custom settings and
there you can choose any collation you want. This collation will be the
default for new databases and it will be the collation of the system
databases. However, you can attach or restore SQL7/SQL2K databases that
have any collation, and you create new databases with any collation by
using the COLLATION clause of the create database statement.

See the BOL topic: Specifying the Default Collation for an Instance of SQL
Server

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.