Home Forums SQL Server 2008 T-SQL (SS2K8) Executed as user: MVS\sqlserver. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468). The step failed. RE: Executed as user: MVS\sqlserver. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468). The step failed.

  • September 2, 2013 at 1:26 am

    #1646680

    Hi,

    It will be easier to read if you also put the error message in the post itself (instead of only as subject). From the error message it seems like you have al collation conflict between the linked server connection and the originating server. Specify the desired collation in the query on the string-columns ((N)VARCHAR and (N)CHAR column types). Something like:

    SELECT

    int_colum1

    , int_column2

    , char_column1 COLLATE Latin1_General_CI_AS as 'char_column1'

    , char_column2 COLLATE Latin1_General_CI_AS as 'char_column2'

    , int_column3

    ...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **