We created a data warehouse that gets data from our Management System. We were getting errors then realized that the Management System was created as Case Sensitive. when we changed our database from CI to CS all worked fine. However, now when we add new tables to our database and try to use them in queries we get:
"Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation."
We are getting this error in Enterprise and in MS Access.
Why are we getting when we work with the new tables?