Thanks for your reply...

So basically I will have to backup and restore the database but reinstall 2005 first with the correct collation and then restore the database with the proper collation ( alter collate )

Although the older objects in the restored database will retain in previous collation.

Correct ?

thx