Post reply

Second Instance of SQL, trying to query from another server

  • May 9, 2005 at 10:38 am

    #92994

    Hi

    Please can you help, we have a  clustered server with two instances of SQL.

    I want to query the second instance from the first, so my query looks like

    select * from sfisql02\doci.Intranet.dbo.Calendar, and I am running this from the first instance of SQL (SFISQLCLUSTER01)

    However SQL just doesn't like the name. SFISQL02\doci is a linked server

     

     

  • May 9, 2005 at 2:44 pm

    #557702

    Try [SFISQL02\doci]. and see if that works.



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • May 11, 2005 at 3:51 am

    #557993

    So simple yet so effective!

    Many Thanks

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

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