Welcome to Sign in | Help
» Search

Search

You searched for the word(s):
Showing page 15 of 18 (176 total posts) < 1 second(s)
  • Re: link-servers on views

    am incercat in interogarea respectiva inainte de a posta si cu aliasuri
    Posted to T-SQL (Forum) by neo on February 2, 2009
  • 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 ...
    Posted to T-SQL (Forum) by neo on February 2, 2009
  • link-servers on views

    Salut, &nbsp; am o mica nelamuririe (pe sql server 2005): intr-un view daca am secventa : ''select * from [link-server].[db].[dbo].[tabel]'' nam nici o problema dar daca am un inner join cu niste conditii si trebuie sa folosesc link serverul ar trebui sa mearga? (eu zic ca da dar e ceva ce nu imi iese...?!?!?) Exista vre-o limitare de genul ...
    Posted to T-SQL (Forum) by neo on February 2, 2009
  • Re: Tranzactii distribuite

    unul dintre mesajele descrise anterior&nbsp;zicea ceva Distributed Transaction. Asa ca mi se parea ca de acolo tre sa fie. L-am configurat ca atare si a mers. Nu accepta conexiuni remote. Practic asta era problema. Inainte de asta am mai facut o setare la link server : Allow Data Access: True ca sa imi mearga selecturile pe link server : insa dupa ...
    Posted to T-SQL (Forum) by neo on January 21, 2009
  • Re: Tranzactii distribuite

    &nbsp; Done.&nbsp;&nbsp; &nbsp;(DTC neconfigurat) se configureaza DTC-un si este totul ok &nbsp; &nbsp; &nbsp;
    Posted to T-SQL (Forum) by neo on January 21, 2009
  • Re: Tranzactii distribuite

    am luat la mana dtc-urile, restart servere si e ok &nbsp; Multumesc &nbsp;
    Posted to T-SQL (Forum) by neo on January 20, 2009
  • Re: Tranzactii distribuite

    le-am verificat andrei pe ambele . In principiu am verificat Link Serverele, protocoalele pe ambele servere, DTC-ul, si am sa mai verific linkurile tale&nbsp;
    Posted to T-SQL (Forum) by neo on January 20, 2009
  • Re: Tranzactii distribuite

    Este vorba despre SQL 2005 Standard Eddition SP1 pe care am o aplicatie care citeste / scrie iar datele sunt replicate tranzactional pe un alt server. Miam reinstalat serverul&nbsp; si inainte de reinstalare a mers dar acum imi da eroarea : ''OLE DB provider ''SQLNCLI'' for linked server ''xx'' returned message ''The partner transaction manager ...
    Posted to T-SQL (Forum) by neo on January 20, 2009
  • Tranzactii distribuite

    Salut , Am si eu o problema si inca nu i-am dat de cap: Intr-un domeniu (Active Directory sub 2003 server) pe un SQL Server Standar ed cu SP1, am o eroare in profiler care zice asa: ''The operation could not be performed because OLE DB provider ''SQLNCLI'' for linked server'' Am verificat sa fie pornit DTC din Run\dcomcnfg.exe cred ca e o ...
    Posted to T-SQL (Forum) by neo on January 20, 2009
  • Re: replicari

    Evident ca nu replic aceeasi tabela cu 2 replicari : sunt 2 baze de date diferite aferente celor 2 tipuri de replicari...
    Posted to T-SQL (Forum) by neo on January 11, 2009
« First ... < Previous 13 14 15 16 17 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems