June 16, 2010 at 12:05 pm
so i'm running this on a sql 2008 box. It's using linked server to pull all the tables from a db called c-tab. When i run this
"SELECT *
FROM [MYAPDB12].[c-tab].INFORMATION_SCHEMA.Tables WHERE TABLE_TYPE = 'BASE TABLE' "
from the 2005 box i get the error below.
----+++++++++++++++++++
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "MYAPDB12" does not contain the table ""c-tab"."INFORMATION_SCHEMA"."Tables"". The table either does not exist or the current user does not have permissions on that table.
--+++++++++++++++++++++
However when i run this i get results returned
SELECT *
FROM [MYAPDB12].[c-tab].dbo.Affstats
June 16, 2010 at 12:22 pm
I needed to do something similiar and based on my research you can not access information_schema context in a linked server. every forum I visited ended in the same resolution. you must create a veiw on the linked server and then reference that veiw.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 16, 2010 at 3:00 pm
Figures.
I'll get the data from a different sys table.
Thanks for your response.....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply