If your existing data may contain extended ascii (åäö and such), you'd probably want to store away your data before changing collation.

The 'old and proven' way is something along these lines...

1) Script out the db and all objects in it. (remove all references to COLLATION that is wrong)

2) BCP out all data from all tables. (store in a safe place, or two..)

3) Drop the db.

4) Create db with the desired collation

5) Create all objects from the script(s) (tables, procs, views, triggers, users etc..)

... make sure that the script(s) has no references to the 'old' collation

6) BCP all data back in again.

7) Done, go have a beer. =;o)

/Kenneth