Trying to run a query across multiple server with incorrect collation settings

Posted on 2007-10-18
Last Modified: 2008-09-08
I am trying to run a select statement across a linked server where the join is based on a field of the same type (char) on both databases, but one of the database I believe was setup incorrectly a long time ago and I have no ability to change it

FROM table1 t1
JOIN table2 t1 on t1.code = t2.code

The error I am getting is
"Cannot resolve collation conflict for equal to operation."

Is there anyway of adding a collation type to the select statement so thay I can compare correctly?
Or is there anything else I can do

Question by:mikelittlewood
    LVL 8

    Accepted Solution

    If you are running the query across a linked server you need to user servername.databasename.tablename when you write your select statement

    for e.g

    Select * from servername.databasename.tablename

    Hope this helps.

    LVL 15

    Author Comment

    Sorry my bad I should have written that in as I am already

    FROM table1 t1
    JOIN serverlink.cat1.dbo.table2 t1 on t1.code = t2.code

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now