Hello
Does any one have an idea what can I do to solv this problem
(an address is alumni.winweb.pl on a home page I have also some errors....):
_____________________________________________________________
Errors Occurred
Error in file:f:\users\alumni.winweb.pl\wwwroot\installer\SqlScripts\cs_UpdateSchemaAndProcedures.sqlMessage:Cannot resolve the collation conflict between "Polish_CI_AI" and "Polish_CI_AS" in the equal to operation. Schema Patch v3.1.4 was applied successfully Creating...cs_Schema_Patch_3.1.05
Hi standio,
First, this issue will be resolved in our next release of Community Server 2008 (RC).
If you need to get thru it today, your best option would be to modify the SQL in the failing scripts to include "collate database_default" wherever you're creating a column that requires specific collation settings.
You can also use the database_default option in the COLLATE clause to specify that a column in a temporary table use the collation default of the current user database for the connection instead of tempdb. [source]
Basically whenever a temp table is created, it uses the collation settings of the *tempdb* database, not the current database. If those differ and then a join is performed, you get the error you encountered.
Again, we have already resolved this issue and it'll be available in our upcoming release. Thanks!
One is glad to be of service...
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com