I'm trying to query a table that is on a different server. So I did
something like this:
select *
from server.database.dbo.tablename
Strange thing is that this works on every table in that database except for
one. Everytime I try to query from that table, I get this error:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Any ideas?
Thanks,
Tim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
