• Are these objects created with SCHEMABINDING clause? You have to script them, drop them, change db collation and recreate them from script.

    What is collation of the tempdb database? If it is different than the one you want change to on your database you will have problems with temptables and subqueries that compare character fields.

    Piotr

    ...and your only reply is slàinte mhath