I'm not really a collation expert, but since 2000 (and in 2005), databases can have separate collations, so there isn't an impact with the server collation.

If you are moving data between databases, you'd have to really dig in and see if there are potential issues with the data you use.