Microsoft SQL Server - Azure .net db collation error

I am trying to select against the Project Works data base to get details outside the defined templates.
However I get a collation error when I try to interrogate for the table/view lists

I don’t know why people change their data sets away from the standard collation, but it does happen (legacy inherited probably)

The point is I cannot select against this azure dataset even thought he connection is made looking at the error.

Any help or suggestions ?

1 Like