Welcome to Sign in | Help

Synonym pe un tabel remote avand o coloana de tip XML

  •  09-24-2013, 7:05 AM

    Synonym pe un tabel remote avand o coloana de tip XML

    Hello world.
    Am urmatoarea problema.
    Avand 2 servere(Server 1 si Server 2). Pe Server 1 creez un synonym al unui tabel care se afla pe Server 2 si care
    contine o coloana de tip XML. Synonym-ul se creaza, dar nu poate fi accesat, generand urmatoarea eroare (select * from Synonym_name / select convert(nvarchar(max), XML_column) from Synonym_name):
    "Msg 9514, Level 16, State 1, Line 1
    Xml data type is not supported in distributed queries. Remote object 'Synonym_name' has xml column(s).".
    Va multumesc.
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems