Linked servers and assumed dbo ownership of tables on target database
I have a scenario where I am wanting to query data via linked servers - so I add target databases on the linked servers to my connection (the master server) - good. I can then write a simple LINQ query, a c# expression. This fails and I think the reason is this. The tables that I am interested in on target database are not dbo owned, rather a specific owner (I have no control over this). If I look at the SQL generated by LINQPad I notice that it has assumed dbo ownership. How can I get this to work? LINQPad seems happy to work with non-dbo ownership when not querying through linked servers. Any ideas? Thx, James
Comments
I seem to have the same problem, only the [ dbo] owned tables and views can be seen.