• For a single database this codeproject solution (updated for SQL 2005) may still be worth a look:

    http://www.codeproject.com/KB/database/ChangeCollation.aspx