Wrong schema for linked server

I'm adding an additional db using a linked server but the tables show up with an incorrect schema and thus I cannot query these tables since they, rightly, state that there is no table with that schema on the linked server.

Comments

  • Can you run a SQL Profiler while building datacontext and compare the output of these queries with the actual database schema?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!