sifuhall
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just a thought make sure you are looking at the correct db withing sql server.
-Navicerts
-Navicerts
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.