Multiple Server query -- sql server mseq

Chris W
4/27/2004 7:23:49 AM

I'm trying to write a query that will be used in a stored
proc to grab data from a table on a different server.
So I have SVR1 trying to get data from SVR2, so I'm trying
to use this query:

SELECT * FROM SVR2..TESTDB.TESTTBL

but I get the following error:
OLE DB provider 'SVR2' does not contain
table '"dbo"."master"'. The table either does not exist
or the current user does not have permissions on that
table.
OLE DB error trace [Non-interface error: OLE DB provider
does not contain the table: ProviderName='SVR2',
TableName='"dbo"."master"'].

Can anyone help?

Thanks,
Chris

Steve Kass
4/28/2004 2:38:21 AM

Chris,

It seems more likely that you would want

select * from SVR2.TESTDB..TESTTBL

though I'm not quite sure why you get this particular error. What did
you use to add the server SVR2?

Steve Kass
Drew University

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server mseq

sql server mseq : Multiple Server query