Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 getting data from views through linked servers

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2009-07-29 : 12:34:23
Hi All,
i've configured linked server between two servers, and is working fine for me with the tables. while i'm trying to get the data from views, i'm getting error like

OLE DB provider 'SQLServername' does not contain table '"database"."dbo"."viewname"'. The table either does not exist or the current user does not have permissions on that table.

please let me know where i'm missing

Arnav
Even you learn 1%, Learn it with 100% confidence.
   

- Advertisement -