Scenario:

Drop MyTable1

Select Into MyTable1 From MyView1 

Drop MyTable2

Select Into MyTable2 From MyView2

Adding a relationship between 2 varchar fields fails because the field has different collation.

So, in both views, I

CAST(MyField AS varchar(11)) COLLATE database_default

much good that i does me. The first table always has the offending field as database default,while the second one always has SQL_Latin1_General_CP1_CI_AS.

What's the trick that I'm missing?

TIA