InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 22:45:39 GMT20http://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspxYes, I wanted to post above what the fix was in case anybody else runs into this.If you're going from 2012 SP1 to 2005 SP3 (probably from 2012 of any flavor to 2005 of any flavor) and get a collation conflict that you are sure isn't there (because you have inspected everything from point a to point z).Try deleting the linked server and recreating it. Try each of the most common connection libraries as well.Fri, 15 Feb 2013 10:35:54 GMTmtassinhttp://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspxIn other words, you are sorted?Fri, 15 Feb 2013 10:04:06 GMTJan Van der Eeckenhttp://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspxI'm aware of the differences between what is shown. However looking at the actual collations at the server, database, table and column levels they were always SQL_Latin1_General_CP1_CI_ASIn this case it turns out to somehow have been a busted linked server of all oddities.Rebuilding the linked server that the queries were passing to resolved the collation conflict that was not there.I had tried building it using SQL Native Client 10 and 11. 10 had worked when it was a 2008R2 server, and the client was still present on the server, 11 was working when I made actual connections to the SQL 2005 SP3 server.When I changed the client to use MSOLEDB instead of the Native Client the collation error problems went away.Fri, 15 Feb 2013 07:25:13 GMTmtassinhttp://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspx[quote][b]Lynn Pettis (2/15/2013)[/b][hr][quote][b]Jan Van der Eecken (2/15/2013)[/b][hr]Mark, did you copy and paste the error message directly from SSMS? If yes, then they are indeed different. Just look closely, the one is Latin1_General_CI_AS, and the other one is SQL_Latin1_General_[b]CP1[/b]_CI_AS (note the CP1 part).[/quote]Even more of a difference than that, one is a windows collation and the other a SQL collation.[/quote]:w00t:Fri, 15 Feb 2013 06:20:29 GMTJan Van der Eeckenhttp://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspx[quote][b]Jan Van der Eecken (2/15/2013)[/b][hr]Mark, did you copy and paste the error message directly from SSMS? If yes, then they are indeed different. Just look closely, the one is Latin1_General_CI_AS, and the other one is SQL_Latin1_General_[b]CP1[/b]_CI_AS (note the CP1 part).[/quote]Even more of a difference than that, one is a windows collation and the other a SQL collation.Fri, 15 Feb 2013 06:06:00 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspxMark, did you copy and paste the error message directly from SSMS? If yes, then they are indeed different. Just look closely, the one is Latin1_General_CI_AS, and the other one is SQL_Latin1_General_[b]CP1[/b]_CI_AS (note the CP1 part).Fri, 15 Feb 2013 04:51:58 GMTJan Van der Eeckenhttp://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspxUnfortunately, we can't see what you see so it is hard to know what to tell you.Thu, 14 Feb 2013 16:13:23 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1420285-3077-1.aspxI have the following error coming back at meMsg 468, Level 16, State 9, Line 243Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.Except that the server collations are all SQL_Latin1_General_CP1_CI_ASThe database collations are SQL_Latin1_General_CP1_CI_ASThe Table collations are SQL_Latin1_General_CP1_CI_ASand the specific column in question is using SQL_Latin1_General_CP1_CI_AS as its collation as well.This worked fine with SQL 2008 R2 SP1 SQL_Latin1_General_CP1_CI_AS and SQL 2005 SP3, is this something to do with SQL 2012 SP1?Thu, 14 Feb 2013 13:53:16 GMTmtassin