Jon,
Thanx! for the info. But you see, my problem is that the collation on the tables are from another server (w/c is the correct one). During my installation of the new server I selected the wrong one. So what I wanted to do was change the collation order of the new server to match the old one 8 )
Actually, I ended up re-installing the SQL of the new server. Thanx! again for the tip though. I'm sure it will come in handy someday.
Regards,
Martin
Shit happens!!!