correct as stated [will still keep existing column collations]. or ...

1. script all current tables without explicit collation [and pref in dependency order]

2. install SQL200x to get the instance to the collation that you want

3. create an empty db with the correct db name with the desired [i.e. same as instance] collation

4. fire your script to create tables with the desired [i.e. same as db] collation

5. use DTS or SSIS to actually populate new db with data from existing one

it is ugly to have mixed collation because any string comparison might need explicit collation

- not self-contained to dodgydb as one frequently needs to use tempdb for temp/group/sorting

HTH

Dick