I am currently testing moving from sql7 to new server with sql 2000.
These resources should help
knowledge base article 314546 and 240872
Also 2000 Books on line selecting a SQL Collation.
Things to look out for...
1. Make sure your collation on system databases match the collation on user ones after restore. If they dont have to either reinstall or run rebuildm.exe
2. Moving logins use sp_help_revlogin and then sp_change_users_login. This seems to work nicely.
Will let you know if I come across anything else.