InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 21:00:13 GMT20http://www.sqlservercentral.com/Forums/Topic850316-145-1.aspxOK - I've answered my own question.Although the database and table was set to Latin1_General_CI_AS one of the columns used was set to Latin1_General_CI_AS_KS_WS - hence the issueWed, 20 Jan 2010 04:10:30 GMTStuart Davieshttp://www.sqlservercentral.com/Forums/Topic850316-145-1.aspxEvery night we collect data from the reportserver database and archive it into another database (Utils). The Utils database has a collation of Latin1_General_CI_AS as does the table in the query below.Although this isn't a problem as we have resolved the issue, I am intrigued as to why when we run :-SELECT [ReportName] ,REPLACE([Path] ,[ReportName],'') ,[Path] ,[NumberofTimesRun] ,[LastRun] ,[avgDurationSecs] FROM [Utils].[dbo].[ReportUsageSummary]ORDER BY [Path]we get Msg 468, Level 16, State 9, Line 1Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "Latin1_General_CI_AS" in the replace operation.This issue is resolved by the following :SELECT [ReportName] ,REPLACE([Path] COLLATE Latin1_General_CS_AS_KS_WS,[ReportName],'') ,[Path] ,[NumberofTimesRun] ,[LastRun] ,[avgDurationSecs] FROM [Utils].[dbo].[ReportUsageSummary]ORDER BY [Path]Can anyone explain why we get this error when only one table is queried?Wed, 20 Jan 2010 02:38:27 GMTStuart Davies