Post reply

Why is the query not working across servers

  • January 5, 2017 at 4:24 pm

    #339188

    Select top 100 TimeStamp

    FROM MHPAPP2.PROVIDERSYSTEM.DBO.AddressGeoCode;

    I get the error

    Msg 7325, Level 16, State 1, Line 1

    Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object '"PROVIDERSYSTEM"."DBO"."AddressGeoCode"'.

  • January 5, 2017 at 4:49 pm

    #1921012

    mw112009 (1/5/2017)

    Select top 100 TimeStamp

    FROM MHPAPP2.PROVIDERSYSTEM.DBO.AddressGeoCode;

    I get the error

    Msg 7325, Level 16, State 1, Line 1

    Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object '"PROVIDERSYSTEM"."DBO"."AddressGeoCode"'.

    It's not working pretty much for the reason in the message - you have columns with CLR types. So you need to use OPENQUERY instead.

    Sue

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

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