• The information you have provided does not compute. Are you sure your login has access to that table?

    What does this return?

    SELECT *

    FROM OPENDATASOURCE('SQLNCLI', 'Data Source=DESTSERVR\INSTANCE;Integrated Security=SSPI').TESTTBL.sys.tables

    WHERE name = 'TBLNAME';

    What about when using a username and password?

    SELECT *

    FROM OPENDATASOURCE('SQLNCLI', 'Data Source=DESTSERVR\INSTANCE;user id=test;password=psw').TESTTBL.sys.tables

    WHERE name = 'TBLNAME';

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato