The collation properties of columns <Columnname> and <Columnname> do not match. (Visual Database Tools)

Each pair of corresponding columns from the primary-key table and foreign-key table of a relationship must have identical collation settings, but this relationship includes a pair of corresponding columns with different settings. Remove the columns from the relationship or change the collation settings to be identical.

See Also

Concepts

Error Messages in Visual Database Tools

Help and Information

Getting SQL Server 2005 Assistance