>Why is it that the Collation setting for a column can appear to be different in SSMS when viewing column properties in the explorer and looking at them in the table designer ?
Have you refreshed that object? Did you change the collation? Also, what is your exact SQL Server version?
If it's not broken, fix it until it is.
My Blog