Does anybody know how i could use a linked server as a data source for a report model in SQL server 2008 r2? or how i could make this linked server a data source on a report model? Please help. Thank you.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Why not just put the datapull for the linked data source in a stored procedure and then access it from a "local" database?
The two ideas are unrelated
There are some cases where the DataSet calls a SQL Server database that uses a linked server: but I suspect you aren't that far yet.
If you think you need to use a "linked server" to call one database only to get data from another database, then why not call the other database directly. And stop thinking of linked servers