Hi all,
On our databases we usually set the collation as
'SQL_Latin1_General_CP1_CI_AS'. One of our clients recently had a
problem where none of their queries would run. When we checked the
collation on their sql server, the server and all the other databases
were at 'Latin1_General_CI_AS'. Also for our db the SQLSortOrder was
'52' while for the master/model/tempdb the SQLSortOrder was '0' (as
displayed by sp_helpdb)

This is the error they were receiving:
Server: Msg 446, Level 16, State 9, Procedure cbo0001p_parms_upd_tlc,
Line 36
Cannot resolve collation conflict for equal to operation.

sql:
update cbord.cbo0001p_parms
set usertext1 = 'XXX',
usertext2 = '0013-xxxxxx',
where parmname = 'EOD';
go

As I understand it since their SortRule(Lanti1), Case Sensitivity and
Accent Sensitivity is same, shouldnt the comparisons work fine?


Thanx in advance,
Amol.

MS Sql Server LazyDBA home page