I want to transfer a database (*.mdf and *.ldf) from one server to another. When I detached the original files and the tried to attach the new ones I got the error message:
"Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server."
So how can I transfer a database form one server to another it the two servers use differnet sort orders etc?
Bengt