Post reply

Calling a Linked Sever

  • April 6, 2006 at 2:48 pm

    #168912

    Hey Guys,

    I need some help I have 2 SQL Server 'servers', one is connected to the orther through a linked server. I need to call one table in the linked server I read once that if you have a linked server between SQL Server dabatabases you don't need to use the OpenQuery, what I read says that I could call my linked server as a database so insted of OPENQUERY(lnkServer,'select * from query'&nbsp I could say lnkServer..Query. But It has not worked for me yet and I don't know if I am missing something..

     

    Thanks,

    Felipe

  • April 6, 2006 at 4:03 pm

    #631370

    Thanks guys anyway no answer necessary now, I found what is the way to do it...

     

  • April 6, 2006 at 4:03 pm

    #631369

    Proper call:

    <Server>.<Database>.<Owner>.<Object>

     

    _____________
    Code for TallyGenerator

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

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