Welcome to Sign in | Help

Re: link-servers on views

  •  02-02-2009, 8:38 PM

    Re: link-servers on views

    Select-ul din view este:

    select db.dbo.tabel1.coloana, db.dbo.tabel1.coloana, db.dbo.tabel2.coloana

    from db.dbo.tabel1 inner join db.dbo.tabel2

    on db.dbo.tabel1.id=db.dbo.tabel2.id and db.dbo.tabel1.id2=db.dbo.tabel2.id2

    where conditii

    Eroarea este : "Msg 4104, Level 16, State 1, Line 2" The multi-part identifier "dbo...." could not be bound.

    secventa de mai sus o rulez pe o masina iar db-ul se afla pe alta masina: deci inainte de db mai trebui pus un link-server (un select chir pe l;ink server e ok dar la ceva de genu cum e mai sus: nu vrea)

     


    G.
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems