Yes.
In SQL 2000, you can setup collation at server level, database level, table level and column level.
You dont have to fear that you have to rebuild the master if you use default collation for the box. You can create a database/tabl/column in a different collation.
Awesome is'nt it?