I just want to say thanks to this guy because he found a solution I just was trying to do. When you are using the DataTierGenerator for Enterprise Library 2.0 and try to connect to a SQL database that has a Collation different to “Latin1_General_CI_AS” it just can’t work. The reason is because the function “FN_LISTEXTENDEDPROPERTY” force the use of “Latin1_General_CI_AS”. To solve this problem we need to just specify the collation in our Schema queries.
If you try to read this post you will find where exactly.