Created On:  19 October 2010

Problem:

We attempted to create a new Workspace on SQL 2008 database and received a "Cannot Create Workspace" error.  The error message will involve something similar to Column Name Does Not Exist.

Resolution:

Modernization Workbench can not find the Column name due to case-sensitivity on the SQL server.  This can be resolved by changing the setting on the SQL server to remove case-sensitivity.

The database property "COLLATE" should be changed to "SQL_Latin1_General_CS_AS" which is not case-sensitive.  The user should now be able to create the Workspace.
Incident #2482126