My Techie Blog

  Home  |   Contact  |   Syndication    |   Login
  110 Posts | 5 Stories | 406 Comments | 0 Trackbacks

News

Archives

Post Categories

Image Galleries

ADO.NET

Ajax

API/WebServices

ASP.NET Resources

BizTalk Server

Blogs I read

Free Books

How to

iOT

JavaScript

JQuery

JSLink - SharePoint

JSON

LINQ

Misc

Mobile BI

MS Business Inteliigence

Reporting Services

Responsive/MVC ASP.NET

SEO

Sharepoint Resources/Tools

SharePoint 2010 Branding

SharePoint 2010 Videos

SharePoint 2013

SharePoint Online

SilverLight

SPServices

SQL Server

Sql Server 2012

SSIS

Web Optimization Tools

Web Performace Tools

Windows 8

Windows Azure

Windows Azure

Windows Phone

WorkFlows

WSS V3

xml

I was writing a store proc for a report and i needed some data from another server
so i added a linked server to connect to this new db server.

when i do a select like below its all fine

select a,b,c from Server.DatabaseName.dbo.table

But when i use the table in a join i get the error

"Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."

I did check the collation set on the 2 databases and it was actually the same and had mo idea why i'm getting the error.

I later found out that you could specifically tell it to use a COLLATE
Just rewrite your join like this

on a.name COLLATE Latin1_General_CI_AS = eaobjname

Hope that helps and saves your precious time
Patrick

 

posted on Friday, April 30, 2010 12:34 AM