SQL Server Performance Forum – Threads Archive
Invalid schema or catalogWhy if i omit object owner i am getting an error Statement select * from [servername].master..sysservers
: Invalid schema or catalog specified for provider ‘Local Server’.
OLE DB error trace [Non-interface error: Invalid schema or catalog specified for the provider.]. But stetement select * from [servername].master.dbo.sysservers works fine.
As its on linked server you can use OPENQUERY. _________
Catalog and schema are ANSI terms that mean database and object owner in SQL Server terms, and object_name refers to a table or whatever object type works for the OLE DB provider you’re using. _________
One of the requirements of a distributed query is that you have to provide a ‘full’ four-part name of the object.
This is an extract from the ‘Configuring Linker Servers’ section of BOL: When executing a distributed query against a linked server, include a fully qualified, four-part table name for each data source to query. This four-part name should be in the form linked_server_name.catalog.schema.object_name. For more information, see Distributed Queries.