I am designing data model for already existsing tables in a datbase using sql server diagrams.

While defining relation ships between two tables I am getting below error message

The following data typr properties of a column 'Table A' does not match those of 'Table B'


select a column with the same data type properties as the related column.

Intially for Table A i have varchar(20) data type and table B varchar(255). I changed table A to be varchar(255) but still throwing the same error.

I have refreshed the tables and also added the changed table again in to the diagram but still same error

Re: data base diagram error in sql 2005


Moving to more appropriate forum.

Try closing and re-opening Management Studio. It may be caching some values.