I thought the whole thing with the openquery was to get around the open with the 4 named setup.. The Open query just utilizes the linked server name, so isn't it redundant to require it on the outside of the call and the inside of the call??
As stated, I can't get the Database or the schema to work.. I get the following...
An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "Shemp01"
when I enter the following
select am.L_name
from Shemp.ar01.[PUBLIC].armast
The catalog I need to take my 3rd party vendor at their word. But the schema PUBLIC is visible to me in the table list under the linked Sever setup.
So Am I stuck with only using the
EXEC with the open query then?
Main Topics
Browse All Topics





by: aneeshattingalPosted on 2009-10-19 at 11:14:42ID: 25607602
you should have used like this
_executesq l N'select * from .... '
EXEC linkedserver.master.dbo.sp