Post reply

Linked Server

  • December 12, 2005 at 11:50 am

    #111110

    I've setup linked server A to connect to B.  When I run the following select from QA,

    select * from .db.dbo.table

    The return I get is from [A] instead of

    any ideas would be greatly?

     

  • December 12, 2005 at 12:15 pm

    #609077

    How do you know it's coming back from [A]? Are you seeing any activity occuring on ?

    K. Brian Kelley
    @kbriankelley

  • December 14, 2005 at 10:51 am

    #609528

    The row count I'm receiving is identical to A. 

     

    What's the best way to verify if there is activity on B? 

    Thanks

     

  • December 15, 2005 at 1:46 am

    #609646

    I've had queries fail because I haven't set up the link or permissions correctly but never got results from the wrong server when using four part naming.

    I assume that these are permanent real tables (not #, ## or views) with 'sensible' names - no unusual characters.

    I suggest that you create a test table in B with unique data and check that you can read that across the link.

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

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