Link to home
Start Free TrialLog in
Avatar of sifuhall
sifuhallFlag for United States of America

asked on

Table not visible in linked server

I have 2 SQL Servers linked and the connection connects as sa.

I have recently added 3 table, yet when I attempt to access them from the linked database I get the "does not contain table" error.

What must I do to make these tables visible.
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

>>yet when I attempt to access them from the linked database <<
How are you doing this?  If from SQL Query Analyzer, please post your query.  

>>What must I do to make these tables visible.<<
Difficult to tell, but I suspect they were created with a different owner name.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Just a thought make sure you are looking at the correct db withing sql server.

-Navicerts