Post reply

linked server openquery error inconsistent metadata

  • March 8, 2007 at 9:50 am

    #176505

    I didn't find any answers doing searches on this so hopefully this will help someone out. Scenario is: Running SQL 2005 (x86 32 bit version) on one box, and need to read a database on this server from a SQL 2000 box. So I setup a linked server on the 2000 box and tried to use OPENQUERY on it to read the data I want. It works fine but for some queries, particularly ones returning a column of varchar, I get an OLE DB error saying that the metadata has changed and is inconsistent.

    Solution: Turns out after trying many things, I just needed to change the 'Use Remote Collation' setting on the Linked Server to 'False' and that did the trick.

    Hopefully this helps someone else out!

  • March 12, 2007 at 11:49 am

    #694453

    And both of your servers have a different collation?

  • March 12, 2007 at 4:33 pm

    #694531

    Thanks for the tip

    MohammedU
    Microsoft SQL Server MVP

  • March 12, 2007 at 6:20 pm

    #694544

    Nope, both have the same collation, SQL_Latin1_General_CP1_CI_AS.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply